Strange Characters after downloading Chinese table from html

Question

I am using MAC OS X 10.12 system. I downloaded a table from http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2011/51/06/81/510681114.html . The table was encoded with GB2312, however, I used GBK to save the table. The main part of the code is like the following:

req = urllib2.Request(url, headers={ 'User-Agent': 'Mozilla/5.0' })
page = urllib2.urlopen(req ).read()
tables=BeautifulSoup(page,'html.parser',
parse_only=SoupStrainer(),from_encoding='gbk')
f = open(path, 'w')
for row in tables.findAll("tr"):
    cells = row.findAll("td")
    write_to_file = cells[0].find(text=True) + "," + cells[1].find(text=True) 
+ "\n"
    write_to_unicode = write_to_file.encode('utf-8')
    f.write(write_to_unicode)
f.close()

I repeated this pattern of code for many other similar tables, however, for some links (like the one I posted here), the Chinese tables downloaded are with strange characters. Here is the example.

´úÂë,³ÇÏç·ÖÀà,Ãû³Æ
510681114001,121,½ÖµÀ¾ÓÃñίԱ»á
510681114201,220,ðÀÃù´å´åÃñίԱ»á
510681114202,220,°×º×´å´åÃñίԱ»á
510681114203,122,Áâ½Ç´å´åÃñίԱ»á
510681114204,122,»Æ¼Òµê´å´åÃñίԱ»á
510681114205,122,»¨ÌÁ´å´åÃñίԱ»á
510681114206,220,ÔÂÍå´å´åÃñίԱ»á
510681114207,122,°×ÔÆ´å´åÃñίԱ»á
510681114208,220,Á¹Ë®¾®´å´åÃñίԱ»á
510681114209,122,Çàþh´å´åÃñίԱ»á

What should I do to convert this table to real Chinese, or what should I do to download the Chinese table?

The problem is, if I choose to use GB2312, maybe for this table, it can be shown with Chinese correctly, but for other tables, it will still show these annoying strange characters.

Answer 1

I just got the inspiration from here http://zzi.io/?p=275 for example

a=u"´úÂë"
print a.encode('iso-8859-1').decode('gbk')

Result is

代码

So this problem is partly solved.