Python how to write a new csv file using pandas [duplicate]

Question

import pandas as pd
pd.__version__
df = pd.read_csv('myfile.csv', usecols=[0,3,4,5,9])
print (df)

I only want to return these specific columns from my csv file and write it into a new csv file?

How can I do this

so far i can read the data!! but not sure how to write it

ABSOLUTE PYTHON BEGGINER ALERT

df.to_csv('filename.csv')

Ruthger Righart
– Ruthger Righart

2020-10-21 15:07:46 +00:00
Commented Oct 21, 2020 at 15:07 — Ruthger Righart
– Ruthger Righart, Commented Oct 21, 2020 at 15:07

Samtech · Accepted Answer · 2020-10-21 15:32:57Z

1

based on your input, i assume you are trying to achieve something like this ?

#import library
import pandas as pd
pd.__version__

# read the csv with all columns
df = pd.read_csv('myfile.csv')
print (df)

# create csv with filtered columns
filter_cols = ["0","3","4","5","9"]
df.to_csv('output.csv', columns = filter_cols)

edited Oct 21, 2020 at 15:32

answered Oct 21, 2020 at 15:19

Samtech

3396 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Python how to write a new csv file using pandas [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related