python pandas select rows that match one condition and write to a new csv file

Question

I want to select rows that match a condition and write to a new csv file. Here's my code and some sample data and i'm sure the type of 'id' is string. It only gives me the header row in the new file.

import pandas as pd

df = pd.read_csv("data.csv")
df[(df['id'] == '48')].to_csv("out.csv", index=False)

I'm wondering where the problem is. Thanks for the help!

Add sample data of df dataframe

Dishin Goyani
– Dishin Goyani

2020-08-07 06:06:09 +00:00
Commented Aug 7, 2020 at 6:06 — Dishin Goyani
– Dishin Goyani, Commented Aug 7, 2020 at 6:06

prashant0598 · Accepted Answer · 2020-08-07 06:26:24Z

1

It might be happening because id would be a numerical value.

import pandas as pd

df = pd.read_csv("data.csv")
df[(df['id'] == 48)].to_csv("out.csv", index=False)

answered Aug 7, 2020 at 6:26

prashant0598

2333 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

python pandas select rows that match one condition and write to a new csv file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related