Creating new data frame from old dataframe

Question

I want to create a new dataframe having only those rows which has name in the Image_list. Original df has records more than 200,000 whereas Image_list has only 300 list of image names.

for name in Image_list:
    df1= df.loc[df['ID']== name]
    print(df1)
    Final_data.append(df1)

Final_data.shape

'ID' column contains much more than Image_list, for example

['Black_Hair',
 'Eyeglasses',
 'Male',
 'Smiling',
 'Straight_Hair',
 'Wearing_Earrings',
 'Wearing_Necktie']

and need to assign the new data: Final_data = Final_data.append(df1) — blackraven
– blackraven, Commented May 29, 2022 at 13:09
Also, should use pd.concat() instead of df.append(), see my answer — blackraven
– blackraven, Commented May 29, 2022 at 13:17

blackraven · Accepted Answer · 2022-05-29 13:10:16Z

1

You would need to assign the new data to the existing df Final_data. Also, the method df.append() is deprecated. Should use pd.concat() instead

import pandas as pd

Final_data = pd.DataFrame()

for name in Image_list:
    df1 = df[df['ID']==name]
    print(df1.shape)
    Final_data = pd.concat([Final_data, df1])

print(Final_data.shape)

answered May 29, 2022 at 13:10

blackraven

5,6797 gold badges26 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating new data frame from old dataframe

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related