0

I have a 3 datasets. My_tracks, All_tracks, and final_df.

My_tracks - 2544,3

All_tracks - 114000, 19

final_df = new dataframe

I want final_df to have all the songs of my_tracks with shape of all_tracks

required final_df.shape is (n,19) when my_tracks.Track == all_track.track_name append final_df.append(all_tracks

IMAGES OF THE DATAFRAMES All_track My_track

Following is the query that I tried

final_df = all_tracks[all_tracks.track_name.isin(my_tracks.Track)]

or

for i in my_tracks.Track:
    if i in all_track.track_name:
        final_df.append(all_track.loc[])

0 Answers0