CODEWITHSUNDEEP
pythonpandascsv
Saima Pal
Saima Pal

Reputation: 1

return csv.writer(f, dialect=dialect, **kwds) TypeError: "delimiter" must be a 1-character string in python pandas

haotou = int(input("head number "))
yyrangest2 = int(input("start of the middle number"))
yyrangeen2 = int(input("end of the middle number"))
while wan <= 1002:
    for xx in range(0000, 10000):
        for yy in range(yyrangest2, yyrangeen2):
            xxy = str(xx).zfill(4)
            yyy = str(yy).zfill(4)
            print(haotou, yyy, xxy, sep="")
            data = pd.DataFrame({'head': [haotou] , 'middle': [yy], 'the third part': [xx]})
            data.to_csv("test.csv", index=False, sep='')
            wan = wan + 1

and the error is Traceback (most recent call last): File "/Users/jason/PycharmProjects/my day/venv/guess.py", line 16, in data.to_csv("test.csv", index=False, sep='') File "/Users/jason/PycharmProjects/my day/venv/lib/python3.7/site-packages/pandas/core/generic.py", line 3228, in to_csv formatter.save() File "/Users/jason/PycharmProjects/my day/venv/lib/python3.7/site-packages/pandas/io/formats/csvs.py", line 200, in save self.writer = UnicodeWriter(f, **writer_kwargs) File "/Users/jason/PycharmProjects/my day/venv/lib/python3.7/site-packages/pandas/io/common.py", line 517, in UnicodeWriter return csv.writer(f, dialect=dialect, **kwds) TypeError: "delimiter" must be a 1-character string

Upvotes: 0

Views: 723

Answers (1)

Saima Pal
Saima Pal

Reputation: 1

data = data.append([{'seq': zz,'hao': haotou,'middle': yyy,'third': xxy}],ignore_index=True,sort=False) 
data.to_csv("test.csv", index=False, sep=" ")

use this instead and save outside of the loop

Upvotes: 0

Related Questions