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

by

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)

More Related Contents:

  1. A simple maths operation on a CSV column using python [closed]
  2. How to add a new column to a CSV file?
  3. csv.Error: iterator should return strings, not bytes
  4. Scraping Google Finance (BeautifulSoup)
  5. Beautiful Soup findAll doesn’t find them all
  6. portable way to write csv file in python 2 or python 3
  7. Convert HTML into CSV
  8. Convert a HTML Table to JSON
  9. python pandas read_csv delimiter in column data
  10. Beautifulsoup : Difference between .find() and .select()
  11. pandas.read_csv from string or package data
  12. UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x8b in position 1: invalid start byte, while reading csv file in pandas
  13. Pandas ParserError EOF character when reading multiple csv files to HDF5
  14. Read .csv file from URL into Python 3.x – _csv.Error: iterator should return strings, not bytes (did you open the file in text mode?)
  15. how to get text from within a tag, but ignore other child tags
  16. PyQt Class not working for the second usage
  17. Scrape Dynamic contents created by Javascript using Python
  18. Python 3 CSV file giving UnicodeDecodeError: ‘utf-8’ codec can’t decode byte error when I print
  19. How to write List of lists in csv file in python [duplicate]
  20. Python3: writing csv files
  21. Parsing a pipe-delimited file in Python
  22. Why is a list comprehension so much faster than appending to a list?
  23. How can I periodically execute a function with asyncio?
  24. TypeError: worker() takes 0 positional arguments but 1 was given [duplicate]
  25. SyntaxError: Failed to execute ‘evaluate’ on ‘Document’: The string ‘//img[contains(‘1236548597′)]’ is not a valid XPath expression
  26. Why is pandas.to_datetime slow for non standard time format such as ‘2014/12/31’
  27. How can I print multiple things (fixed text and/or variable values) on the same line, all at once?
  28. How to reuse an expression in a comprehension expression?
  29. How to move the background image with keys in pygame?
  30. json.decoder.JSONDecodeError: Extra data: line 2 column 1 (char 190) [duplicate]

Leave a Comment