Pandas read_csv() does not work for me

Question

I have data in this format:

DAX 20150728 11173.910156
DAX 20150727 11056.400391
DAX 20150724 11347.450195
DAX 20150723 11512.110352

If I try to read the data with print pd.read_csv('DAX.csv'), I get this: [6246 rows x 1 columns]. Obviously pandas can not manage to read the three columns of data and get all the data in one column.

How can I fix this?

Okay, I see. Thank you very much!

Jorko12
– Jorko12

2015-07-31 11:03:09 +00:00
Commented Jul 31, 2015 at 11:03 — Jorko12
– Jorko12, Commented Jul 31, 2015 at 11:03

EdChum · Accepted Answer · 2015-07-31 11:06:42Z

1

You need to explicitly pass the separator as the default is comma ',':

In [160]:
t="""DAX 20150728 11173.910156
DAX 20150727 11056.400391
DAX 20150724 11347.450195
DAX 20150723 11512.110352"""
df = pd.read_csv(io.StringIO(t), header=None, sep='\s+',names=['exchange', 'date', 'close'], parse_dates=[1])
df

Out[160]:
  exchange       date         close
0      DAX 2015-07-28  11173.910156
1      DAX 2015-07-27  11056.400391
2      DAX 2015-07-24  11347.450195
3      DAX 2015-07-23  11512.110352

The docs state this.

answered Jul 31, 2015 at 11:06

EdChum

396k204 gold badges836 silver badges583 bronze badges

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

Comments

paya · Accepted Answer · 2015-07-31 11:08:32Z

1

did you try:

variable = pd.read_csv('DAX.csv')

and then:

print variable

answered Jul 31, 2015 at 11:08

paya

111 bronze badge

Collectives™ on Stack Overflow

Pandas read_csv() does not work for me

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related