Shri Vaishnav Vidyapeeth Vishwavidyalaya, Indore (MP)
Pandas Assignment
Data Science-BTIBM505 , All Sections - M,D,E
Submission last Date – 28/Sep/2022
You can perform python Code on any IDE - Pycharm, Jupyter, Colab, Visual Studio Code
1. Import library - Import pandas as pd
2. Create - (v is here variable) v=Series(‘list’, index=(‘r1’,’r2’),dtype=‘str/float’),
v=DataFrame({‘a’:[1,2,3],’b’:[11,12,13]}),v=DataFrame(list,columns=(‘c1’,’c2’), index=(‘r1’,’r2’))
3. Analysis method- v=Read_csv(), v.to_csv(), v.head(), v.tail(), v.describe(), v.info(), v.isnull().sum(), v.corr(), v.count(),
v[‘col’].unique() ,v[‘col’].numique(), v[‘col’].value_counts().sort_value(), v.simple(no.) , type(v), v[‘c’].mean(), v[‘c’].mode,
v[‘c’].median(),v.cumsum(), v.comprod() , df.groupby([‘c1’])[‘c1’].mean()/median()/count()/max
4. Attribute – v.size, v.shape, v.columns, v.ndim, v.dtypes
5. Accessing/Manage/Process/Manipulate – extract pd.Series(v[‘c1’]), extract DataFrame- v[[‘c1’]], extract list- [[v]],
v.set_index(‘c1’),v.sort_index (acending=False,axis=1), v.iloc[ [‘r1’],[‘c1’]], v.iloc[:,[c1]], v.drop([‘r1’,’r2’]) V.drop([‘C1’, ‘C2’], axis =1)
6. Casting in list & Array –v.tolist(in series),v.index.tolist(), v.values.tolist(), v.columns.tolist() v.to_numpy(), v.values (convert array)
7. Drop &Fill Null Value - v.dropna(), v.dropna(axis=1/0,how=‘all/any’), v.fillna(value), v.fill(method=‘ffill/bfill’), v.loc[r2,’c2’]=value,
m=v[‘c1’].mean(), fill={‘c’: m}, v=v.fillna(value=fill)
8. Merge, Append, Concatenate – pd.merge(v1,v2,on=‘col’,how=‘outer/inner/left/right’), v1.append(v2),
pd.concat([v1,v2])
PERFORM THESE METHODS AND OPERATIONS THEN SUBMIT ASSIGNMENT
E https://forms.gle/yyVm6Q8ZoTxNc8fQ8
Om Kant Sharma