How can I read slash when I use read_csv in pandas

Question

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=',')

your delimiter is whitespace, so pass sep = ' ' instead of ',' — sammywemmy, Feb 02 '20 at 12:02
@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

score 0 · Answer 1 · answered Apr 21 '23 at 06:12

0

Try using

pd.read_csv('filepath',sep='\t')

instead of sep=' '

answered Apr 21 '23 at 06:12

1 Answers1