How to create column names in pandas dataframe?

Question

I have exported the gold price data from the brokers. the file has no column names like this

2014.02.13,00:00,1291.00,1302.90,1286.20,1302.30,41906 2014.02.14,00:00,1301.80,1321.20,1299.80,1318.70,46244 2014.02.17,00:00,1318.20,1329.80,1318.10,1328.60,26811 2014.02.18,00:00,1328.60,1332.10,1312.60,1321.40,46226

I read csv to pandas dataframe and it take the first row to be the column names. I am curious how can I set the column names and still have all the data

Thank you

Related - add column names dynamically with an expression stackoverflow.com/a/60461259/495455 — Jeremy Thompson
– Jeremy Thompson, Commented Jul 5, 2022 at 4:01

Sanidhya Singh · Accepted Answer · 2022-07-05 04:05:37Z

12

if you don't have a header in the CSV, you can instruct Pandas to ignore it using the header parameter

df = pd.read_csv(file_path, header=None)

to manually assign column names to the DataFrame, you may use

df.columns = ["col1", "col2", ...]

Encourage you to go through the read_csv documentation to learn more about the options it provides.

edited Jul 5, 2022 at 4:05

answered Jul 5, 2022 at 3:59

Sanidhya Singh

5414 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

How to create column names in pandas dataframe?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related