Dear all,

I hope this topic has not been covered elsewhere, but I searched the forums for "csv" and did not find what I was looking for.

I am having the following problems:

I want to export a ZOTERO collection with currently 2173 entries to a CSV file for data analysis in Python.

I have used the export to CSV option in the stand-alone version, but when I open the CSV file in EXCEL to check what it looks like, it has 10165 rows (each with their own key or document ID) rather than 2174 (which is what I would have expected). Individual books seem to come up more than twenty times although this is not the case in the collection itself. And there might be other issues.

Just to be sure, I wrote a Python script that simply counts the number of rows in my CSV file, but when the counter reaches 87, the script breaks and gives me the following error notification:

>>>
RESTART: U:\Dokumente\DH technologies\HGIS\GIS with Python\Python Geocoder\Geocoding in Python_testfiles\GeocodeCSV.py
87
Traceback (most recent call last):
File "U:\Dokumente\DH technologies\HGIS\GIS with Python\Python Geocoder\Geocoding in Python_testfiles\GeocodeCSV.py", line 21, in
for row in data:
File "C:\Users\mobarget\AppData\Local\Programs\Python\Python37\lib\encodings\cp1252.py", line 23, in decode
return codecs.charmap_decode(input,self.errors,decoding_table)[0]
UnicodeDecodeError: 'charmap' codec can't decode byte 0x81 in position 7936: character maps to
>>>

What I eventually want to do is geocode the places of publication and use my tags for data analysis, but if I cannot even get my data out of ZOTERO as they should be, I won't be getting anywhere with that.

A trial script to retrieve specific information such as publication years from individual rows of data worked fine but broke after circa 65 results. This was the error notification I got there:

>>>
Traceback (most recent call last):
File "U:\Dokumente\DH technologies\HGIS\GIS with Python\Python Geocoder\Geocoding in Python_testfiles\GeocodeCSV.py", line 20, in
for row in data:
File "C:\Users\mobarget\AppData\Local\Programs\Python\Python37\lib\encodings\cp1252.py", line 23, in decode
return codecs.charmap_decode(input,self.errors,decoding_table)[0]
UnicodeDecodeError: 'charmap' codec can't decode byte 0x81 in position 7936: character maps to
>>>

Your help is very much appreciated! If you think it is better to use a different file format (e.g. JSON) for the analysis I would like to do, please let me know.

Best wishes, Monika