m8_

remove rows when selected

m8_
Sep 12th, 2019
578
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.55 KB | None | 0 0
  1. import pandas as pd
  2.  
  3. # make some data and create dataframe
  4. data1 = [['Alex',10],['Bob',12],['Clarke',13],
  5.          ['Alex',80],['Bob',73],['Clarke',45],
  6.          ['Alex',45],['Bob',43],['Clarke',98]]
  7. df1 = pd.DataFrame(data1,columns=['Name','Age'])
  8.  
  9. # select rows
  10. df2 = df1.loc[df1['Name'] == 'Alex']
  11.  
  12. # TO-DO - how to remove the selected rows in df2 from df1
  13.  
  14. # intended result
  15. result_data = [['Bob',12],['Clarke',13],
  16.          ['Bob',73],['Clarke',45],
  17.          ['Bob',43],['Clarke',98]]
  18. result_df = pd.DataFrame(result_data,columns=['Name','Age'])
Advertisement
Add Comment
Please, Sign In to add comment