TypeError: a bytes-like object is required, not 'str' in python and CSV TypeError: a bytes-like object is required, not 'str' in python and CSV python python

TypeError: a bytes-like object is required, not 'str' in python and CSV


You are using Python 2 methodology instead of Python 3.

Change:

outfile=open('./immates.csv','wb')

To:

outfile=open('./immates.csv','w')

and you will get a file with the following output:

SNo,States,Dist,Population1,Andhra Pradesh,13,493787762,Arunachal Pradesh,16,13826113,Assam,27,311692724,Bihar,38,1038046375,Chhattisgarh,19,255401966,Goa,2,14577237,Gujarat,26,60383628.....

In Python 3 csv takes the input in text mode, whereas in Python 2 it took it in binary mode.

Edited to Add

Here is the code I ran:

url='http://www.mapsofindia.com/districts-india/'html = urllib.request.urlopen(url).read()soup = BeautifulSoup(html)table=soup.find('table', attrs={'class':'tableizer-table'})list_of_rows=[]for row in table.findAll('tr')[1:]:    list_of_cells=[]    for cell in row.findAll('td'):        list_of_cells.append(cell.text)    list_of_rows.append(list_of_cells)outfile = open('./immates.csv','w')writer=csv.writer(outfile)writer.writerow(['SNo', 'States', 'Dist', 'Population'])writer.writerows(list_of_rows)


I had the same issue with Python3.My code was writing into io.BytesIO().

Replacing with io.StringIO() solved.


just change wb to w

outfile=open('./immates.csv','wb')

to

outfile=open('./immates.csv','w')