I am trying to create a .csv file with the values from a Python list. When I print the values in the list they are all unicode (?), i.e. they look something like this [u’value 1′, u’value 2′, …] If I iterate through the values in the list i.e. for v in mylist: print v … Read more
The new version of Pandas uses the following interface to load Excel files: read_excel(‘path_to_file.xls’, ‘Sheet1’, index_col=None, na_values=[‘NA’]) but what if I don’t know the sheets that are available? For example, I am working with excel files that the following sheets Data 1, Data 2 …, Data N, foo, bar but I don’t know N a … Read more
This question already has answers here: Pandas cannot open an Excel (.xlsx) file (4 answers) Closed 1 year ago. I am trying to read a macro-enabled Excel worksheet using pandas.read_excel with the xlrd library. It’s running fine in local, but when I try to push the same into PCF, I am getting this error: 2020-12-11T21:09:53.441+05:30 … Read more
