Reading tab-delimited file with Pandas – works on Windows, but not on Mac

Michael Zippo

👻 Check our latest review to choose the best laptop for Machine Learning engineers and Deep learning tasks!

I"ve been reading a tab-delimited data file in Windows with Pandas/Python without any problems. The data file contains notes in first three lines and then follows with a header.

df = pd.read_csv(myfile,sep="	",skiprows=(0,1,2),header=(0))

I"m now trying to read this file with my Mac. (My first time using Python on Mac.) I get the following error.

pandas.parser.CParserError: Error tokenizing data. C error: Expected 1
fields in line 8, saw 39

If set the error_bad_lines argument for read_csv to False, I get the following information, which continues until the end of the last row.

Skipping line 8: expected 1 fields, saw 39
Skipping line 9: expected 1 fields, saw 125
Skipping line 10: expected 1 fields, saw 125
Skipping line 11: expected 1 fields, saw 125
Skipping line 12: expected 1 fields, saw 125
Skipping line 13: expected 1 fields, saw 125
Skipping line 14: expected 1 fields, saw 125
Skipping line 15: expected 1 fields, saw 125
Skipping line 16: expected 1 fields, saw 125
Skipping line 17: expected 1 fields, saw 125
...

Do I need to specify a value for the encoding argument? It seems as though I shouldn"t have to because reading the file works fine on Windows.

👻 Read also: what is the best laptop for engineering students?

Reading tab-delimited file with Pandas - works on Windows, but not on Mac del: Questions

__del__

How can I make a time delay in Python?

5 answers

I would like to know how to put a time delay in a Python script.

2973

Answer #1

import time
time.sleep(5)   # Delays for 5 seconds. You can also use a float value.

Here is another example where something is run approximately once a minute:

import time
while True:
    print("This prints once a minute.")
    time.sleep(60) # Delay for 1 minute (60 seconds).

2973

Answer #2

You can use the sleep() function in the time module. It can take a float argument for sub-second resolution.

from time import sleep
sleep(0.1) # Time in seconds

Reading tab-delimited file with Pandas - works on Windows, but not on Mac del: Questions

__del__

How to delete a file or folder in Python?

5 answers

How do I delete a file or folder in Python?

2639

Answer #1

os.remove() removes a file.
os.rmdir() removes an empty directory.
shutil.rmtree() deletes a directory and all its contents.

Path objects from the Python 3.4+ pathlib module also expose these instance methods:

pathlib.Path.unlink() removes a file or symbolic link.
pathlib.Path.rmdir() removes an empty directory.

We hope this article has helped you to resolve the problem. Apart from Reading tab-delimited file with Pandas – works on Windows, but not on Mac, check other __del__-related topics.

Want to excel in Python? See our review of the best Python online courses 2023. If you are interested in Data Science, check also how to learn programming in R.

By the way, this material is also available in other languages:

Julia Jackson

New York | 2023-03-24

code Python module is always a bit confusing 😭 Reading tab-delimited file with Pandas – works on Windows, but not on Mac is not the only problem I encountered. I just hope that will not emerge anymore

Olivia Danburry

Paris | 2023-03-24

token Python module is always a bit confusing 😭 Reading tab-delimited file with Pandas – works on Windows, but not on Mac is not the only problem I encountered. Checked yesterday, it works!

Oliver Chamberlet

Rome | 2023-03-24

Maybe there are another answers? What Reading tab-delimited file with Pandas – works on Windows, but not on Mac exactly means?. Will get back tomorrow with feedback