Write specifics rows with specific column values in python csv

Question

I have a csv file and I need to write lines with a common value in one of the columns in another csv file, how can I do this?

Sorry I meant once read where do you store ? My point is using numpy or pandas would make this easier. — J.C
– J.C, Commented Apr 9, 2020 at 15:19
I fail to see why you cannot just find the value, assign it to a variable and use this variable when saving your new CSV — J.C
– J.C, Commented Apr 9, 2020 at 15:19

FAHAD SIDDIQUI · Accepted Answer · 2020-04-09 15:39:54Z

4

As I understand your problem, you want to read csv file, then based on a condition on any column's value you want to filter it and finally write into a csv file. If I am correct then you can do the following :

#Import pandas

import pandas as pd

#Read your csv file as pandas dataframe
df = pd.read_csv("your_csv_file_name")

#Apply filter condition
df = df[df['Column_name_for_fitering'] == "Value_for_filtering"]

# Save as new csv file
df.to_csv('your_output_file_name')

answered Apr 9, 2020 at 15:39

FAHAD SIDDIQUI

6414 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Write specifics rows with specific column values in python csv

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