Pandas giving error to read txt data file

Question

This is the code that I am using and it is not working for some reason. Please help me out.

I have created a text file with some data and when I try to use Pandas to read the data it is not working.

dF = pd.read_csv("PandasLongSample.txt", delimiter='/t')
print(dF)

This is the error:

C:\Users\SVISHWANATH\AppData\Local\Continuum\anaconda3\lib\site-packages\ipykernel_launcher.py:1: ParserWarning: Falling back to the 'python' engine because the 'c' engine does not support regex separators (separators > 1 char and different from '\s+' are interpreted as regex); you can avoid this warning by specifying engine='python'.
  """Entry point for launching an IPython kernel.

Thanks for the help!

Trisoloriansunscreen · Accepted Answer · 2020-06-14 18:26:04Z

3

Use a backslash (\) instead of a slash (/) for the tab delimiter.

dF = pd.read_csv("PandasLongSample.txt", delimiter='\t')
print(dF)

edited Jun 14, 2020 at 18:26

answered Jun 14, 2020 at 4:01

Trisoloriansunscreen

1,6432 gold badges17 silver badges30 bronze badges

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

Comments

sushanth · Accepted Answer · 2020-06-14 09:39:19Z

0

There is a typo in your code, it should be \t instead of /t

edited Jun 14, 2020 at 9:39

sushanth

8,2923 gold badges20 silver badges31 bronze badges

answered Jun 14, 2020 at 4:03

Yuvraj singh

112 bronze badges

Collectives™ on Stack Overflow

Pandas giving error to read txt data file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related