Python Bytes - Panda Dataframe Drop Duplicates
import pandas as pd
ipl_data = {'Team': ['Riders', 'Riders', 'Devils', 'Devils', 'Kings',
'Kings', 'Kings', 'Kings', 'Riders', 'Royals', 'Royals', 'Riders'],
'Rank': [1, 2, 2, 3, 3,4 ,1 ,1,2 , 4,1,2],
'Year': [2014,2015,2014,2015,2014,2015,2016,2017,2016,2014,2015,2017],
'Points':[876,789,863,673,741,812,756,788,694,701,804,690]}
df = pd.DataFrame(ipl_data)
w = df[df["Team"].str.contains("Devil")]
x = df[df["Team"].str.contains("Royals")]
y = df[df["Team"].str.contains("King")]
z = df[df["Rank"] == 1]
frames = [w,x,y,z]
res1 = pd.concat(frames)
res2=res1.sort_values(by=['Team','Rank','Year','Points'])
result_df = res1.drop_duplicates()
print(result_df)
Watch video Python Bytes - Panda Dataframe Drop Duplicates online without registration, duration hours minute second in high quality. This video was added by user AC 14 May 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 871 once and liked it 12 people.