Created
June 13, 2021 23:46
-
-
Save pushkarsaini18/9b7d08e9a3aa7a86782de5e8c25dc677 to your computer and use it in GitHub Desktop.
Untitled7.ipynb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "cells": [ | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "id": "4d039f88", | |
| "cell_type": "code", | |
| "source": "import pandas as pd\nimport numpy as np", | |
| "execution_count": 4, | |
| "outputs": [] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "id": "76fbcb9e", | |
| "cell_type": "code", | |
| "source": "df= pd.read_csv(\"G:/Data science/Salaries.csv\")", | |
| "execution_count": 5, | |
| "outputs": [] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "id": "0939bc4d", | |
| "cell_type": "code", | |
| "source": "df\n", | |
| "execution_count": 8, | |
| "outputs": [ | |
| { | |
| "output_type": "execute_result", | |
| "execution_count": 8, | |
| "data": { | |
| "text/plain": " rank discipline phd service sex salary\n0 Prof B 56 49 Male 186960\n1 Prof A 12 6 Male 93000\n2 Prof A 23 20 Male 110515\n3 Prof A 40 31 Male 131205\n4 Prof B 20 18 Male 104800\n.. ... ... ... ... ... ...\n73 Prof B 18 10 Female 105450\n74 AssocProf B 19 6 Female 104542\n75 Prof B 17 17 Female 124312\n76 Prof A 28 14 Female 109954\n77 Prof A 23 15 Female 109646\n\n[78 rows x 6 columns]", | |
| "text/html": "<div>\n<style scoped>\n .dataframe tbody tr th:only-of-type {\n vertical-align: middle;\n }\n\n .dataframe tbody tr th {\n vertical-align: top;\n }\n\n .dataframe thead th {\n text-align: right;\n }\n</style>\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>rank</th>\n <th>discipline</th>\n <th>phd</th>\n <th>service</th>\n <th>sex</th>\n <th>salary</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>0</th>\n <td>Prof</td>\n <td>B</td>\n <td>56</td>\n <td>49</td>\n <td>Male</td>\n <td>186960</td>\n </tr>\n <tr>\n <th>1</th>\n <td>Prof</td>\n <td>A</td>\n <td>12</td>\n <td>6</td>\n <td>Male</td>\n <td>93000</td>\n </tr>\n <tr>\n <th>2</th>\n <td>Prof</td>\n <td>A</td>\n <td>23</td>\n <td>20</td>\n <td>Male</td>\n <td>110515</td>\n </tr>\n <tr>\n <th>3</th>\n <td>Prof</td>\n <td>A</td>\n <td>40</td>\n <td>31</td>\n <td>Male</td>\n <td>131205</td>\n </tr>\n <tr>\n <th>4</th>\n <td>Prof</td>\n <td>B</td>\n <td>20</td>\n <td>18</td>\n <td>Male</td>\n <td>104800</td>\n </tr>\n <tr>\n <th>...</th>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n </tr>\n <tr>\n <th>73</th>\n <td>Prof</td>\n <td>B</td>\n <td>18</td>\n <td>10</td>\n <td>Female</td>\n <td>105450</td>\n </tr>\n <tr>\n <th>74</th>\n <td>AssocProf</td>\n <td>B</td>\n <td>19</td>\n <td>6</td>\n <td>Female</td>\n <td>104542</td>\n </tr>\n <tr>\n <th>75</th>\n <td>Prof</td>\n <td>B</td>\n <td>17</td>\n <td>17</td>\n <td>Female</td>\n <td>124312</td>\n </tr>\n <tr>\n <th>76</th>\n <td>Prof</td>\n <td>A</td>\n <td>28</td>\n <td>14</td>\n <td>Female</td>\n <td>109954</td>\n </tr>\n <tr>\n <th>77</th>\n <td>Prof</td>\n <td>A</td>\n <td>23</td>\n <td>15</td>\n <td>Female</td>\n <td>109646</td>\n </tr>\n </tbody>\n</table>\n<p>78 rows × 6 columns</p>\n</div>" | |
| }, | |
| "metadata": {} | |
| } | |
| ] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "id": "5e7ed74d", | |
| "cell_type": "code", | |
| "source": "View(df)", | |
| "execution_count": 7, | |
| "outputs": [ | |
| { | |
| "output_type": "error", | |
| "ename": "NameError", | |
| "evalue": "name 'View' is not defined", | |
| "traceback": [ | |
| "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m", | |
| "\u001b[1;31mNameError\u001b[0m Traceback (most recent call last)", | |
| "\u001b[1;32m<ipython-input-7-d75c8c14c1b2>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mView\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdf\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m", | |
| "\u001b[1;31mNameError\u001b[0m: name 'View' is not defined" | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "id": "3b7ccf04", | |
| "cell_type": "code", | |
| "source": "df.head()", | |
| "execution_count": null, | |
| "outputs": [] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": false | |
| }, | |
| "id": "16bd897d", | |
| "cell_type": "code", | |
| "source": "", | |
| "execution_count": 9, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/plain": "array([['Prof', 'B', 56, 49, 'Male', 186960],\n ['Prof', 'A', 12, 6, 'Male', 93000],\n ['Prof', 'A', 23, 20, 'Male', 110515],\n ['Prof', 'A', 40, 31, 'Male', 131205],\n ['Prof', 'B', 20, 18, 'Male', 104800],\n ['Prof', 'A', 20, 20, 'Male', 122400],\n ['AssocProf', 'A', 20, 17, 'Male', 81285],\n ['Prof', 'A', 18, 18, 'Male', 126300],\n ['Prof', 'A', 29, 19, 'Male', 94350],\n ['Prof', 'A', 51, 51, 'Male', 57800],\n ['Prof', 'B', 39, 33, 'Male', 128250],\n ['Prof', 'B', 23, 23, 'Male', 134778],\n ['AsstProf', 'B', 1, 0, 'Male', 88000],\n ['Prof', 'B', 35, 33, 'Male', 162200],\n ['Prof', 'B', 25, 19, 'Male', 153750],\n ['Prof', 'B', 17, 3, 'Male', 150480],\n ['AsstProf', 'B', 8, 3, 'Male', 75044],\n ['AsstProf', 'B', 4, 0, 'Male', 92000],\n ['Prof', 'A', 19, 7, 'Male', 107300],\n ['Prof', 'A', 29, 27, 'Male', 150500],\n ['AsstProf', 'B', 4, 4, 'Male', 92000],\n ['Prof', 'A', 33, 30, 'Male', 103106],\n ['AsstProf', 'A', 4, 2, 'Male', 73000],\n ['AsstProf', 'A', 2, 0, 'Male', 85000],\n ['Prof', 'A', 30, 23, 'Male', 91100],\n ['Prof', 'B', 35, 31, 'Male', 99418],\n ['Prof', 'A', 38, 19, 'Male', 148750],\n ['Prof', 'A', 45, 43, 'Male', 155865],\n ['AsstProf', 'B', 7, 2, 'Male', 91300],\n ['Prof', 'B', 21, 20, 'Male', 123683],\n ['AssocProf', 'B', 9, 7, 'Male', 107008],\n ['Prof', 'B', 22, 21, 'Male', 155750],\n ['Prof', 'A', 27, 19, 'Male', 103275],\n ['Prof', 'B', 18, 18, 'Male', 120000],\n ['AssocProf', 'B', 12, 8, 'Male', 119800],\n ['Prof', 'B', 28, 23, 'Male', 126933],\n ['Prof', 'B', 45, 45, 'Male', 146856],\n ['Prof', 'A', 20, 8, 'Male', 102000],\n ['AsstProf', 'B', 4, 3, 'Male', 91000],\n ['Prof', 'B', 18, 18, 'Female', 129000],\n ['Prof', 'A', 39, 36, 'Female', 137000],\n ['AssocProf', 'A', 13, 8, 'Female', 74830],\n ['AsstProf', 'B', 4, 2, 'Female', 80225],\n ['AsstProf', 'B', 5, 0, 'Female', 77000],\n ['Prof', 'B', 23, 19, 'Female', 151768],\n ['Prof', 'B', 25, 25, 'Female', 140096],\n ['AsstProf', 'B', 11, 3, 'Female', 74692],\n ['AssocProf', 'B', 11, 11, 'Female', 103613],\n ['Prof', 'B', 17, 17, 'Female', 111512],\n ['Prof', 'B', 17, 18, 'Female', 122960],\n ['AsstProf', 'B', 10, 5, 'Female', 97032],\n ['Prof', 'B', 20, 14, 'Female', 127512],\n ['Prof', 'A', 12, 0, 'Female', 105000],\n ['AsstProf', 'A', 5, 3, 'Female', 73500],\n ['AssocProf', 'A', 25, 22, 'Female', 62884],\n ['AsstProf', 'A', 2, 0, 'Female', 72500],\n ['AssocProf', 'A', 10, 8, 'Female', 77500],\n ['AsstProf', 'A', 3, 1, 'Female', 72500],\n ['Prof', 'B', 36, 26, 'Female', 144651],\n ['AssocProf', 'B', 12, 10, 'Female', 103994],\n ['AsstProf', 'B', 3, 3, 'Female', 92000],\n ['AssocProf', 'B', 13, 10, 'Female', 103750],\n ['AssocProf', 'B', 14, 7, 'Female', 109650],\n ['Prof', 'A', 29, 27, 'Female', 91000],\n ['AssocProf', 'A', 26, 24, 'Female', 73300],\n ['Prof', 'A', 36, 19, 'Female', 117555],\n ['AsstProf', 'A', 7, 6, 'Female', 63100],\n ['Prof', 'A', 17, 11, 'Female', 90450],\n ['AsstProf', 'A', 4, 2, 'Female', 77500],\n ['Prof', 'A', 28, 7, 'Female', 116450],\n ['AsstProf', 'A', 8, 3, 'Female', 78500],\n ['AssocProf', 'B', 12, 9, 'Female', 71065],\n ['Prof', 'B', 24, 15, 'Female', 161101],\n ['Prof', 'B', 18, 10, 'Female', 105450],\n ['AssocProf', 'B', 19, 6, 'Female', 104542],\n ['Prof', 'B', 17, 17, 'Female', 124312],\n ['Prof', 'A', 28, 14, 'Female', 109954],\n ['Prof', 'A', 23, 15, 'Female', 109646]], dtype=object)" | |
| }, | |
| "execution_count": 9, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": false | |
| }, | |
| "id": "6e6d6939", | |
| "cell_type": "code", | |
| "source": " dir(df)", | |
| "execution_count": 10, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/plain": "['T',\n '_AXIS_LEN',\n '_AXIS_ORDERS',\n '_AXIS_REVERSED',\n '_AXIS_TO_AXIS_NUMBER',\n '_HANDLED_TYPES',\n '__abs__',\n '__add__',\n '__and__',\n '__annotations__',\n '__array__',\n '__array_priority__',\n '__array_ufunc__',\n '__array_wrap__',\n '__bool__',\n '__class__',\n '__contains__',\n '__copy__',\n '__deepcopy__',\n '__delattr__',\n '__delitem__',\n '__dict__',\n '__dir__',\n '__divmod__',\n '__doc__',\n '__eq__',\n '__finalize__',\n '__floordiv__',\n '__format__',\n '__ge__',\n '__getattr__',\n '__getattribute__',\n '__getitem__',\n '__getstate__',\n '__gt__',\n '__hash__',\n '__iadd__',\n '__iand__',\n '__ifloordiv__',\n '__imod__',\n '__imul__',\n '__init__',\n '__init_subclass__',\n '__invert__',\n '__ior__',\n '__ipow__',\n '__isub__',\n '__iter__',\n '__itruediv__',\n '__ixor__',\n '__le__',\n '__len__',\n '__lt__',\n '__matmul__',\n '__mod__',\n '__module__',\n '__mul__',\n '__ne__',\n '__neg__',\n '__new__',\n '__nonzero__',\n '__or__',\n '__pos__',\n '__pow__',\n '__radd__',\n '__rand__',\n '__rdivmod__',\n '__reduce__',\n '__reduce_ex__',\n '__repr__',\n '__rfloordiv__',\n '__rmatmul__',\n '__rmod__',\n '__rmul__',\n '__ror__',\n '__round__',\n '__rpow__',\n '__rsub__',\n '__rtruediv__',\n '__rxor__',\n '__setattr__',\n '__setitem__',\n '__setstate__',\n '__sizeof__',\n '__str__',\n '__sub__',\n '__subclasshook__',\n '__truediv__',\n '__weakref__',\n '__xor__',\n '_accessors',\n '_accum_func',\n '_add_numeric_operations',\n '_agg_by_level',\n '_agg_examples_doc',\n '_agg_summary_and_see_also_doc',\n '_aggregate',\n '_align_frame',\n '_align_series',\n '_arith_method',\n '_attrs',\n '_box_col_values',\n '_builtin_table',\n '_can_fast_transpose',\n '_check_inplace_and_allows_duplicate_labels',\n '_check_inplace_setting',\n '_check_is_chained_assignment_possible',\n '_check_label_or_level_ambiguity',\n '_check_setitem_copy',\n '_clear_item_cache',\n '_clip_with_one_bound',\n '_clip_with_scalar',\n '_cmp_method',\n '_combine_frame',\n '_consolidate',\n '_consolidate_inplace',\n '_construct_axes_dict',\n '_construct_axes_from_arguments',\n '_construct_result',\n '_constructor',\n '_constructor_expanddim',\n '_constructor_sliced',\n '_convert',\n '_count_level',\n '_cython_table',\n '_data',\n '_dir_additions',\n '_dir_deletions',\n '_dispatch_frame_op',\n '_drop_axis',\n '_drop_labels_or_levels',\n '_ensure_valid_index',\n '_find_valid_index',\n '_flags',\n '_from_arrays',\n '_get_agg_axis',\n '_get_axis',\n '_get_axis_name',\n '_get_axis_number',\n '_get_axis_resolvers',\n '_get_block_manager_axis',\n '_get_bool_data',\n '_get_cacher',\n '_get_cleaned_column_resolvers',\n '_get_column_array',\n '_get_cython_func',\n '_get_index_resolvers',\n '_get_item_cache',\n '_get_label_or_level_values',\n '_get_numeric_data',\n '_get_value',\n '_getitem_bool_array',\n '_getitem_multilevel',\n '_gotitem',\n '_hidden_attrs',\n '_indexed_same',\n '_info_axis',\n '_info_axis_name',\n '_info_axis_number',\n '_info_repr',\n '_init_mgr',\n '_inplace_method',\n '_internal_names',\n '_internal_names_set',\n '_is_builtin_func',\n '_is_cached',\n '_is_copy',\n '_is_homogeneous_type',\n '_is_label_or_level_reference',\n '_is_label_reference',\n '_is_level_reference',\n '_is_mixed_type',\n '_is_view',\n '_iset_item',\n '_item_cache',\n '_iter_column_arrays',\n '_ix',\n '_ixs',\n '_join_compat',\n '_logical_func',\n '_logical_method',\n '_maybe_cache_changed',\n '_maybe_update_cacher',\n '_metadata',\n '_mgr',\n '_min_count_stat_function',\n '_needs_reindex_multi',\n '_obj_with_exclusions',\n '_protect_consolidate',\n '_reduce',\n '_reindex_axes',\n '_reindex_columns',\n '_reindex_index',\n '_reindex_multi',\n '_reindex_with_indexers',\n '_replace_columnwise',\n '_repr_data_resource_',\n '_repr_fits_horizontal_',\n '_repr_fits_vertical_',\n '_repr_html_',\n '_repr_latex_',\n '_reset_cache',\n '_reset_cacher',\n '_sanitize_column',\n '_selected_obj',\n '_selection',\n '_selection_list',\n '_selection_name',\n '_series',\n '_set_as_cached',\n '_set_axis',\n '_set_axis_name',\n '_set_axis_nocheck',\n '_set_is_copy',\n '_set_item',\n '_set_value',\n '_setitem_array',\n '_setitem_frame',\n '_setitem_slice',\n '_slice',\n '_stat_axis',\n '_stat_axis_name',\n '_stat_axis_number',\n '_stat_function',\n '_stat_function_ddof',\n '_take_with_is_copy',\n '_to_dict_of_blocks',\n '_try_aggregate_string_function',\n '_typ',\n '_update_inplace',\n '_validate_dtype',\n '_values',\n '_where',\n 'abs',\n 'add',\n 'add_prefix',\n 'add_suffix',\n 'agg',\n 'aggregate',\n 'align',\n 'all',\n 'any',\n 'append',\n 'apply',\n 'applymap',\n 'asfreq',\n 'asof',\n 'assign',\n 'astype',\n 'at',\n 'at_time',\n 'attrs',\n 'axes',\n 'backfill',\n 'between_time',\n 'bfill',\n 'bool',\n 'boxplot',\n 'clip',\n 'columns',\n 'combine',\n 'combine_first',\n 'compare',\n 'convert_dtypes',\n 'copy',\n 'corr',\n 'corrwith',\n 'count',\n 'cov',\n 'cummax',\n 'cummin',\n 'cumprod',\n 'cumsum',\n 'describe',\n 'diff',\n 'discipline',\n 'div',\n 'divide',\n 'dot',\n 'drop',\n 'drop_duplicates',\n 'droplevel',\n 'dropna',\n 'dtypes',\n 'duplicated',\n 'empty',\n 'eq',\n 'equals',\n 'eval',\n 'ewm',\n 'expanding',\n 'explode',\n 'ffill',\n 'fillna',\n 'filter',\n 'first',\n 'first_valid_index',\n 'flags',\n 'floordiv',\n 'from_dict',\n 'from_records',\n 'ge',\n 'get',\n 'groupby',\n 'gt',\n 'head',\n 'hist',\n 'iat',\n 'idxmax',\n 'idxmin',\n 'iloc',\n 'index',\n 'infer_objects',\n 'info',\n 'insert',\n 'interpolate',\n 'isin',\n 'isna',\n 'isnull',\n 'items',\n 'iteritems',\n 'iterrows',\n 'itertuples',\n 'join',\n 'keys',\n 'kurt',\n 'kurtosis',\n 'last',\n 'last_valid_index',\n 'le',\n 'loc',\n 'lookup',\n 'lt',\n 'mad',\n 'mask',\n 'max',\n 'mean',\n 'median',\n 'melt',\n 'memory_usage',\n 'merge',\n 'min',\n 'mod',\n 'mode',\n 'mul',\n 'multiply',\n 'ndim',\n 'ne',\n 'nlargest',\n 'notna',\n 'notnull',\n 'nsmallest',\n 'nunique',\n 'pad',\n 'pct_change',\n 'phd',\n 'pipe',\n 'pivot',\n 'pivot_table',\n 'plot',\n 'pop',\n 'pow',\n 'prod',\n 'product',\n 'quantile',\n 'query',\n 'radd',\n 'rank',\n 'rdiv',\n 'reindex',\n 'reindex_like',\n 'rename',\n 'rename_axis',\n 'reorder_levels',\n 'replace',\n 'resample',\n 'reset_index',\n 'rfloordiv',\n 'rmod',\n 'rmul',\n 'rolling',\n 'round',\n 'rpow',\n 'rsub',\n 'rtruediv',\n 'salary',\n 'sample',\n 'select_dtypes',\n 'sem',\n 'service',\n 'set_axis',\n 'set_flags',\n 'set_index',\n 'sex',\n 'shape',\n 'shift',\n 'size',\n 'skew',\n 'slice_shift',\n 'sort_index',\n 'sort_values',\n 'squeeze',\n 'stack',\n 'std',\n 'style',\n 'sub',\n 'subtract',\n 'sum',\n 'swapaxes',\n 'swaplevel',\n 'tail',\n 'take',\n 'to_clipboard',\n 'to_csv',\n 'to_dict',\n 'to_excel',\n 'to_feather',\n 'to_gbq',\n 'to_hdf',\n 'to_html',\n 'to_json',\n 'to_latex',\n 'to_markdown',\n 'to_numpy',\n 'to_parquet',\n 'to_period',\n 'to_pickle',\n 'to_records',\n 'to_sql',\n 'to_stata',\n 'to_string',\n 'to_timestamp',\n 'to_xarray',\n 'transform',\n 'transpose',\n 'truediv',\n 'truncate',\n 'tz_convert',\n 'tz_localize',\n 'unstack',\n 'update',\n 'value_counts',\n 'values',\n 'var',\n 'where',\n 'xs']" | |
| }, | |
| "execution_count": 10, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "id": "1da711c9", | |
| "cell_type": "code", | |
| "source": "sal=df['salary']", | |
| "execution_count": 10, | |
| "outputs": [] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "cell_type": "code", | |
| "source": "sal.arrange()", | |
| "execution_count": 12, | |
| "outputs": [ | |
| { | |
| "output_type": "error", | |
| "ename": "AttributeError", | |
| "evalue": "'Series' object has no attribute 'arrange'", | |
| "traceback": [ | |
| "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m", | |
| "\u001b[1;31mAttributeError\u001b[0m Traceback (most recent call last)", | |
| "\u001b[1;32m<ipython-input-12-a463ed7433cd>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0msal\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0marrange\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m", | |
| "\u001b[1;32m~\\anaconda\\lib\\site-packages\\pandas\\core\\generic.py\u001b[0m in \u001b[0;36m__getattr__\u001b[1;34m(self, name)\u001b[0m\n\u001b[0;32m 5463\u001b[0m \u001b[1;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_info_axis\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_can_hold_identifiers_and_holds_name\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mname\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 5464\u001b[0m \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mname\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 5465\u001b[1;33m \u001b[1;32mreturn\u001b[0m \u001b[0mobject\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m__getattribute__\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mname\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m 5466\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 5467\u001b[0m \u001b[1;32mdef\u001b[0m \u001b[0m__setattr__\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mname\u001b[0m\u001b[1;33m:\u001b[0m \u001b[0mstr\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;33m->\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n", | |
| "\u001b[1;31mAttributeError\u001b[0m: 'Series' object has no attribute 'arrange'" | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "cell_type": "code", | |
| "source": "df.iloc[1:10, 0:5]", | |
| "execution_count": 38, | |
| "outputs": [ | |
| { | |
| "output_type": "execute_result", | |
| "execution_count": 38, | |
| "data": { | |
| "text/plain": " rank discipline phd service sex\n1 Prof A 12 6 Male\n2 Prof A 23 20 Male\n3 Prof A 40 31 Male\n4 Prof B 20 18 Male\n5 Prof A 20 20 Male\n6 AssocProf A 20 17 Male\n7 Prof A 18 18 Male\n8 Prof A 29 19 Male\n9 Prof A 51 51 Male", | |
| "text/html": "<div>\n<style scoped>\n .dataframe tbody tr th:only-of-type {\n vertical-align: middle;\n }\n\n .dataframe tbody tr th {\n vertical-align: top;\n }\n\n .dataframe thead th {\n text-align: right;\n }\n</style>\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>rank</th>\n <th>discipline</th>\n <th>phd</th>\n <th>service</th>\n <th>sex</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>1</th>\n <td>Prof</td>\n <td>A</td>\n <td>12</td>\n <td>6</td>\n <td>Male</td>\n </tr>\n <tr>\n <th>2</th>\n <td>Prof</td>\n <td>A</td>\n <td>23</td>\n <td>20</td>\n <td>Male</td>\n </tr>\n <tr>\n <th>3</th>\n <td>Prof</td>\n <td>A</td>\n <td>40</td>\n <td>31</td>\n <td>Male</td>\n </tr>\n <tr>\n <th>4</th>\n <td>Prof</td>\n <td>B</td>\n <td>20</td>\n <td>18</td>\n <td>Male</td>\n </tr>\n <tr>\n <th>5</th>\n <td>Prof</td>\n <td>A</td>\n <td>20</td>\n <td>20</td>\n <td>Male</td>\n </tr>\n <tr>\n <th>6</th>\n <td>AssocProf</td>\n <td>A</td>\n <td>20</td>\n <td>17</td>\n <td>Male</td>\n </tr>\n <tr>\n <th>7</th>\n <td>Prof</td>\n <td>A</td>\n <td>18</td>\n <td>18</td>\n <td>Male</td>\n </tr>\n <tr>\n <th>8</th>\n <td>Prof</td>\n <td>A</td>\n <td>29</td>\n <td>19</td>\n <td>Male</td>\n </tr>\n <tr>\n <th>9</th>\n <td>Prof</td>\n <td>A</td>\n <td>51</td>\n <td>51</td>\n <td>Male</td>\n </tr>\n </tbody>\n</table>\n</div>" | |
| }, | |
| "metadata": {} | |
| } | |
| ] | |
| }, | |
| { | |
| "metadata": { | |
| "trusted": true | |
| }, | |
| "cell_type": "code", | |
| "source": "gh.mean()", | |
| "execution_count": 24, | |
| "outputs": [ | |
| { | |
| "output_type": "execute_result", | |
| "execution_count": 24, | |
| "data": { | |
| "text/plain": " phd service salary\nrank \nAssocProf 15.076923 11.307692 91786.230769\nAsstProf 5.052632 2.210526 81362.789474\nProf 27.065217 21.413043 123624.804348", | |
| "text/html": "<div>\n<style scoped>\n .dataframe tbody tr th:only-of-type {\n vertical-align: middle;\n }\n\n .dataframe tbody tr th {\n vertical-align: top;\n }\n\n .dataframe thead th {\n text-align: right;\n }\n</style>\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>phd</th>\n <th>service</th>\n <th>salary</th>\n </tr>\n <tr>\n <th>rank</th>\n <th></th>\n <th></th>\n <th></th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>AssocProf</th>\n <td>15.076923</td>\n <td>11.307692</td>\n <td>91786.230769</td>\n </tr>\n <tr>\n <th>AsstProf</th>\n <td>5.052632</td>\n <td>2.210526</td>\n <td>81362.789474</td>\n </tr>\n <tr>\n <th>Prof</th>\n <td>27.065217</td>\n <td>21.413043</td>\n <td>123624.804348</td>\n </tr>\n </tbody>\n</table>\n</div>" | |
| }, | |
| "metadata": {} | |
| } | |
| ] | |
| } | |
| ], | |
| "metadata": { | |
| "kernelspec": { | |
| "name": "python3", | |
| "display_name": "Python 3", | |
| "language": "python" | |
| }, | |
| "varInspector": { | |
| "window_display": false, | |
| "cols": { | |
| "lenName": 16, | |
| "lenType": 16, | |
| "lenVar": 40 | |
| }, | |
| "kernels_config": { | |
| "python": { | |
| "library": "var_list.py", | |
| "delete_cmd_prefix": "del ", | |
| "delete_cmd_postfix": "", | |
| "varRefreshCmd": "print(var_dic_list())" | |
| }, | |
| "r": { | |
| "library": "var_list.r", | |
| "delete_cmd_prefix": "rm(", | |
| "delete_cmd_postfix": ") ", | |
| "varRefreshCmd": "cat(var_dic_list()) " | |
| } | |
| }, | |
| "types_to_exclude": [ | |
| "module", | |
| "function", | |
| "builtin_function_or_method", | |
| "instance", | |
| "_Feature" | |
| ] | |
| }, | |
| "gist": { | |
| "id": "", | |
| "data": { | |
| "description": "Untitled7.ipynb", | |
| "public": true | |
| } | |
| } | |
| }, | |
| "nbformat": 4, | |
| "nbformat_minor": 5 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment