How can I read slash when I use read_csv in pandas

Asked Feb 02 '20 at 12:00

Active Mar 29 '20 at 11:32

Viewed 134 times

I have a csv file like this:

Date
2020/01/22 16:47:37
2020/01/22 16:47:37
.....

but when I use read_csv function I get

0         Jan 22 16:47:37
1         Jan 22 16:47:37
2         Jan 22 16:47:37

How can I read slash when I use read_csv in pandas?

This is my code

import pandas as pd


data=pd.read_csv(path+file,
                 encoding='utf-8-sig',
                 sep=',')

edited Mar 29 '20 at 11:32

Martin Gergov

asked Feb 02 '20 at 12:00

disney82231

your delimiter is whitespace, so pass sep = ' ' instead of ',' – sammywemmy Feb 02 '20 at 12:02
Problem is if test data in excel? – jezrael Feb 02 '20 at 12:05
@sammywemmy I already test sep='' ,but still have error – disney82231 Feb 02 '20 at 12:45
@jezrael successfully if file in excel ,why csv can't read it? – disney82231 Feb 02 '20 at 12:47
What is your context? What do you need this for? Can you use `strftime`? – gust Feb 02 '20 at 13:32

0 Answers0