Adding missing label line

Question

I csv have a file with data lines, but it misses the label line. This label line is a string, coma separated, ready to be appended on top.

import pandas as pd
data = pd.read_csv("C:\\Users\\Desktop\\Trades-List.txt", sep=',')
labelLine = "label1,label2,label3"

How to add the 'labelLine' on top of data and make sure it is properly considered as the label line of the file?

Does this answer your question? [Pandas read in table without headers](https://stackoverflow.com/questions/29287224/pandas-read-in-table-without-headers) — Alex, Mar 14 '23 at 11:41

score 1 · Accepted Answer · answered Mar 14 '23 at 11:40

1

Parameter sep=',' is default, so should be removed, add names with splitted values for columns names:

labelLine = "label1,label2,label3"
data = pd.read_csv("C:\\Users\\Desktop\\Trades-List.txt", names=labelLine.split(','))

answered Mar 14 '23 at 11:40

jezrael

822,522
95
1,334
1,252

score 0 · Answer 2 · answered Mar 14 '23 at 11:41

0

Use the names parameter of read_csv after splitting to list with str.split:

import pandas as pd

labelLine = "label1,label2,label3"

data = pd.read_csv("C:\\Users\\Desktop\\Trades-List.txt", sep=',',
                   names=labelLine.split(','))

answered Mar 14 '23 at 11:41

mozway

194,879
13
39
75

Adding missing label line

2 Answers2