Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- # Creating the first Dataframe using dictionary
- df1 = pd.DataFrame({"NAME":['Jai', 'Princi', 'Gaurav', 'Anuj'], "AGE":[27, 24, 22, 32]})
- # Creating the Second Dataframe using dictionary
- df2 = pd.DataFrame({"NAME":['Tom', 'nick', 'krish', 'jack'], "AGE":[20, 21, 19, 18]})
- #appending values of df2 to df1
- df1 = df1.append(df2)
- print("After Appending \n",df1,"\n")
- #deleting rows with row number zero
- df1 = df1.drop(0)
- print("deleting row\n",df1,"\n")
- #Adding a new dataFrame
- address = ['Delhi', 'Bangalore', 'Chennai', 'Bangalore', 'Chennai', 'Patna']
- df1['Address'] = address
- print("Adding a new column\n",df1,"\n")
- """
- OUTPUT
- After Appending
- NAME AGE
- 0 Jai 27
- 1 Princi 24
- 2 Gaurav 22
- 3 Anuj 32
- 0 Tom 20
- 1 nick 21
- 2 krish 19
- 3 jack 18
- deleting row
- NAME AGE
- 1 Princi 24
- 2 Gaurav 22
- 3 Anuj 32
- 1 nick 21
- 2 krish 19
- 3 jack 18
- Adding a new column
- NAME AGE Address
- 1 Princi 24 Delhi
- 2 Gaurav 22 Bangalore
- 3 Anuj 32 Chennai
- 1 nick 21 Bangalore
- 2 krish 19 Chennai
- 3 jack 18 Patna
- """
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement