As you can see, pyexcel-io not only reads the csv file back but also
recognizes the data types: int, float, date and datetime. However, it
does give your cpu some extra job. When you are handling a large csv file and
the cpu budget is of your concern, you may switch off the type detection feature.
For example, let’s switch all off:

In addition to auto_detect_float and auto_detect_datetime, there is another flag named auto_detect_int, which becomes active only if auto_detect_float is True. Now, let’s play a bit with auto_detect_int:

>>> # This is just an illustration>>> # In reality, you might deal with csv file upload>>> # where you will read from requests.FILES['YOUR_XL_FILE']>>> importjson>>> data=get_data(io)>>> print(json.dumps(data)){"csv": [[1, 2, 3], [4, 5, 6]]}

In general, if you would like to save your csv file into a custom encoding, you
can specify ‘encoding’ parameter. Here is how you write verses of
a finnish song, “Aurinko laskee länteen”[1] into a csv file