Give column name when read csv file pandas

Question

This is the example of my dataset.

>>> user1 = pd.read_csv('dataset/1.csv')
>>> print(user1)
          0  0.69464   3.1735   7.5048
0  0.030639  0.14982  3.48680   9.2755
1  0.069763 -0.29965  1.94770   9.1120
2  0.099823 -1.68890  1.41650  10.1200
3  0.129820 -2.17930  0.95342  10.9240
4  0.159790 -2.30180  0.23155  10.6510
5  0.189820 -1.41650  1.18500  11.0730

How to push down the first column and add the names column [TIME, X, Y, and Z] on the first column.

The desired output is like this:

       TIME        X        Y        Z
0         0  0.69464   3.1735   7.5048
1  0.030639  0.14982  3.48680   9.2755
2  0.069763 -0.29965  1.94770   9.1120
3  0.099823 -1.68890  1.41650  10.1200
4  0.129820 -2.17930  0.95342  10.9240
5  0.159790 -2.30180  0.23155  10.6510
6  0.189820 -1.41650  1.18500  11.0730

wmoco_6725 · Accepted Answer · 2015-07-27 05:33:33Z

274

I'd do it like this:

colnames=['TIME', 'X', 'Y', 'Z'] 
user1 = pd.read_csv('dataset/1.csv', names=colnames, header=None)

answered Jul 27, 2015 at 5:33

wmoco_6725

3,2191 gold badge14 silver badges12 bronze badges

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

4 Comments

Joris Limonier Over a year ago

Is header=None necessary since we provide the column names?

Bernard Esterhuyse Over a year ago

If the column names are supplied, the parameter header is not required. As per the documentation: "if column names are passed explicitly then the behavior is identical to header=None". See pandas.pydata.org/docs/reference/api/pandas.read_csv.html

skan Over a year ago

Can I exclude some of those columns directly?

Seshadri R Over a year ago

header=None produces oodles of error statements. Panda 1.5.3, Python 3.11.4, MacOS Monterey

Hariharan AR · Accepted Answer · 2019-04-11 11:15:38Z

32

we can do it with a single line of code.

 user1 = pd.read_csv('dataset/1.csv', names=['TIME', 'X', 'Y', 'Z'], header=None)

answered Apr 11, 2019 at 11:15

Hariharan AR

1,55614 silver badges22 bronze badges

Comments

Jitesh Mohite · Accepted Answer · 2017-11-04 13:33:50Z

13

If we are directly use data from csv it will give combine data based on comma separation value as it is .csv file.

user1 = pd.read_csv('dataset/1.csv')

If you want to add column names using pandas, you have to do something like this. But below code will not show separate header for your columns.

col_names=['TIME', 'X', 'Y', 'Z'] 
user1 = pd.read_csv('dataset/1.csv', names=col_names)

To solve above problem we have to add extra filled which is supported by pandas, It is header=None

user1 = pd.read_csv('dataset/1.csv', names=col_names, header=None)

answered Nov 4, 2017 at 13:33

Jitesh Mohite

34.5k15 gold badges179 silver badges161 bronze badges

Comments

Mohit Burkule · Accepted Answer · 2021-03-09 16:45:27Z

13

In addition to above answers if your dataset already has column names and you want to replace it with your custom names then set header=0 instead of header=None

answered Mar 9, 2021 at 16:45

Mohit Burkule

1701 silver badge6 bronze badges

2 Comments

Matt Over a year ago

To get them: columns = chunk.columns.tolist()

Sacha Over a year ago

this is so useful I feel like it should at least be mentioned in the answer, even though it's not what the OP asked for

Pradeep · Accepted Answer · 2019-04-11 11:12:23Z

9

user1  = pd.read_csv('dataset/1.csv',  names=['Time',  'X',  'Y',  'Z'])

names parameter in read_csv function is used to define column names. If you pass extra name in this list, it will add another new column with that name with NaN values.

header=None is used to trim column names is already exists in CSV file.

edited Apr 11, 2019 at 11:12

Pradeep

9,68213 gold badges29 silver badges34 bronze badges

answered Apr 11, 2019 at 10:52

Mahendra

1911 silver badge3 bronze badges

Comments

Jiaxiang · Accepted Answer · 2021-05-17 05:15:32Z

1

Use nrows=1 to avoid consuming loading time if the dataset is too large.

answered May 17, 2021 at 5:15

Jiaxiang

88314 silver badges24 bronze badges

Collectives™ on Stack Overflow

Give column name when read csv file pandas

6 Answers 6

4 Comments

Comments

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

4 Comments

Comments

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related