Question
Asked By – markov zain
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
Now we will see solution for issue: Give column name when read csv file pandas
Answer
I’d do it like this:
colnames=['TIME', 'X', 'Y', 'Z']
user1 = pd.read_csv('dataset/1.csv', names=colnames, header=None)
This question is answered By – wmoco_6725
This answer is collected from stackoverflow and reviewed by FixPython community admins, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0