Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- # make some data and create dataframe
- data1 = [['Alex',10],['Bob',12],['Clarke',13],
- ['Alex',80],['Bob',73],['Clarke',45],
- ['Alex',45],['Bob',43],['Clarke',98]]
- df1 = pd.DataFrame(data1,columns=['Name','Age'])
- # select rows
- df2 = df1.loc[df1['Name'] == 'Alex']
- # TO-DO - how to remove the selected rows in df2 from df1
- # intended result
- result_data = [['Bob',12],['Clarke',13],
- ['Bob',73],['Clarke',45],
- ['Bob',43],['Clarke',98]]
- result_df = pd.DataFrame(result_data,columns=['Name','Age'])
Advertisement
Add Comment
Please, Sign In to add comment