Creation of Dataframs
by Ankur Kumar
1. Lists
1.1. Empty Dataframe
1.2. Data frame with 1 List
1.3. Nested Lists
1.4. Using Lists and adding Column names
1.5. Using Lists and adding a specific Data Type
2. Dictionary
2.1. Creation
2.1.1. Create a dictionary and use it to to make a DF
2.1.2. Lists used to make Dictionary, Then make a DF
2.2. Updating Values
2.2.1. df.at[0: _ , 'Age']= 23
2.2.2. df.iloc[ [0,1,2],[2,4] ] =[ '45' , 'M.Ba' ] # 2 columns so 2 values
2.2.3. df.loc[ [0,1,2],['Col_label_1','Col_label_2'] ] = [ '45', 'M.Ba' ]
3. Altering Row indexes & Column names
3.1. Changing 'Row Indexes'. Also called Labels
3.2. Assigning new column names : df.columns = [#New Column names]
3.3. Renaming column names : df.rename(columns = { "A":'a', "B":'b'}, inplace = True)
3.3.1. Renaming a specific column name : df.rename(columns = {"col_name" : 'New name'})
4. Adding/Deleting/Replacing Rows & Columns
4.1. Adding a new column: df[New Column]=List
4.2. Using df.Loc[] to modify rows
4.2.1. Adding a new row : df.Loc[new row index] = ['List Valurs (,)]
4.2.2. Replacing a row : df.Loc[Existing row index] = ['a1','b2','c3']