How to split csv files into multiple ones based on certain values of a dataframe (python)

Question

I have a data as follows

I want to split the csv file based on the ID. GIP1 feature csv files as GIP1.csv and GIP2 as GIP2.csv and so on.

Can anyone please help me how to do this in python?

Anshul Tibrewal · Accepted Answer · 2022-09-30 07:11:46Z

3

So you can use the loc function in pandas. I am assuming you read your csv in as a pandas df

Now you can write a for loop like this:

df = pd.read_csv("gips.csv")
features = df.Id.unique()
for f in features:
    df_split = df.loc[df.ID == f]
    df_split.to_csv(f"{f}.csv")

answered Sep 30, 2022 at 7:11

Anshul Tibrewal

463 bronze badges

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

1 Answer 1