Fix Python – How to add header row to a pandas DataFrame

I am reading a csv file into pandas. This csv file constists of four columns and some rows, but does not have a header row, which I want to add. I have been trying the following:
Cov = pd.read_csv(“path/to/file.txt”, sep=’\t’)
Frame=pd.DataFrame([Cov], columns = [“Sequence”, “Start”, “End”, “Coverage”])
Frame.to_csv(“path/to/file.txt”, sep=’\t’)
….

Fix Python – _csv.Error: field larger than field limit (131072)

I have a script reading in a csv file with very huge fields:
# example from http://docs.python.org/3.3/library/csv.html?highlight=csv%20dictreader#examples
import csv
with open(‘some.csv’, newline=”) as f:
reader = csv.reader(f)
for row in reader:
print(row)

However, this throws the following error on some csv files:
_csv.Error: ….

Fix Python – CSV in Python adding an extra carriage return, on Windows

import csv

with open(‘test.csv’, ‘w’) as outfile:
writer = csv.writer(outfile, delimiter=’,’, quoting=csv.QUOTE_MINIMAL)
writer.writerow([‘hi’, ‘dude’])
writer.writerow([‘hi2’, ‘dude2’])

The above code generates a file, test.csv, with an extra \r at each row, like so:
hi,dude\r\r\nhi2,dude2\r\r\n

instead of the expected
hi,dude\r\nh….

Fix Python – Python Pandas Error tokenizing data

I’m trying to use pandas to manipulate a .csv file but I get this error:

pandas.parser.CParserError: Error tokenizing data. C error: Expected 2 fields in line 3, saw 12

I have tried to read the pandas docs, but found nothing.
My code is simple:
path = ‘GOOG Key Ratios.csv’
#print(open(path).read())
data = pd.read_csv(path)

How can I resolve th….

Fix Python – UnicodeDecodeError when reading CSV file in Pandas with Python

I’m running a program which is processing 30,000 similar files. A random number of them are stopping and producing this error…
File “C:\Importer\src\dfman\importer.py”, line 26, in import_chr
data = pd.read_csv(filepath, names=fields)
File “C:\Python33\lib\site-packages\pandas\io\parsers.py”, line 400, in parser_f
return _read(filepath….