Advertisement
rajath_pai

DataFrame

Mar 1st, 2021 (edited)
229
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.19 KB | None | 0 0
  1. import pandas as pd
  2.  
  3. # Creating the first Dataframe using dictionary
  4. df1 = pd.DataFrame({"NAME":['Jai', 'Princi', 'Gaurav', 'Anuj'],  "AGE":[27, 24, 22, 32]})
  5.  
  6. # Creating the Second Dataframe using dictionary
  7. df2 = pd.DataFrame({"NAME":['Tom', 'nick', 'krish', 'jack'],  "AGE":[20, 21, 19, 18]})
  8.  
  9. #appending values of df2 to df1
  10. df1 = df1.append(df2)
  11.  
  12. print("After Appending \n",df1,"\n")
  13.  
  14. #deleting rows with row number zero
  15. df1 = df1.drop(0)
  16. print("deleting row\n",df1,"\n")
  17.  
  18. #Adding a new dataFrame
  19. address = ['Delhi', 'Bangalore', 'Chennai', 'Bangalore', 'Chennai', 'Patna']
  20. df1['Address'] = address
  21.  
  22. print("Adding a new column\n",df1,"\n")
  23.  
  24.  
  25. """
  26. OUTPUT
  27.  
  28. After Appending
  29.      NAME  AGE
  30. 0     Jai   27
  31. 1  Princi   24
  32. 2  Gaurav   22
  33. 3    Anuj   32
  34. 0     Tom   20
  35. 1    nick   21
  36. 2   krish   19
  37. 3    jack   18
  38.  
  39. deleting row
  40.      NAME  AGE
  41. 1  Princi   24
  42. 2  Gaurav   22
  43. 3    Anuj   32
  44. 1    nick   21
  45. 2   krish   19
  46. 3    jack   18
  47.  
  48. Adding a new column
  49.      NAME  AGE    Address
  50. 1  Princi   24      Delhi
  51. 2  Gaurav   22  Bangalore
  52. 3    Anuj   32    Chennai
  53. 1    nick   21  Bangalore
  54. 2   krish   19    Chennai
  55. 3    jack   18      Patna
  56.  
  57.  
  58. """
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement