read csv without columns in python | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 3

read csv without columns in python

When I use CSV file that does not have columns, I cannot add columns in reading the file. i tried as below but couldn`t data = pd.read_csv("EURJPY5.csv") df = pd.DataFrame(data, columns =["Date", "Time", "High", "Low", "Open", "Close","Volume"]) df.head() >>> Date Time High Low Open Close Volume 0 NaN NaN NaN NaN NaN NaN NaN 1 NaN NaN NaN NaN NaN NaN NaN 2 NaN NaN NaN NaN NaN NaN NaN 3 NaN NaN NaN NaN NaN NaN NaN 4 NaN NaN NaN NaN NaN NaN NaN >>> can you help me please

19th Mar 2019, 2:43 PM
Yソーセージ
Yソーセージ - avatar
2 Answers
+ 7
try to put column names directly in csv reader: data = pd.read_csv("EURJPY5.csv", header=None,names=["Date", "Time", "High", "Low", "Open", "Close","Volume"])
19th Mar 2019, 3:34 PM
Hubert Dudek
Hubert Dudek - avatar
+ 1
thanks so much! I did successfully!!
19th Mar 2019, 3:47 PM
Yソーセージ
Yソーセージ - avatar