TypeError: a bytes-like object is required, not 'str' in python and CSV
TypeError: a bytes-like object is required, not 'str'
I'm getting the above error while executing the below python code to save the HTML table data in a CSV file. How do I get rid of that error?
import csv
import requests
from bs4 import BeautifulSoup
url='http://www.mapsofindia.com/districts-india/'
response=requests.get(url)
html=response.content
soup=BeautifulSoup(html,'html.parser')
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','wb')
writer=csv.writer(outfile)
writer.writerow(["SNo", "States", "Dist", "Population"])
writer.writerows(list_of_rows)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,Population 1,Andhra Pradesh,13,49378776 2,Arunachal Pradesh,16,1382611 3,Assam,27,31169272 4,Bihar,38,103804637 5,Chhattisgarh,19,25540196 6,Goa,2,1457723 7,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)
Get this solution programmatically \u2014 free, no authentication.
curl https://depscope.dev/api/error/ceca60fdc7120c3567a0ceeaaa5298c63ff2d7c8915f9ee09cfa3379231458b5