About the UTF-8 format in importing data with pandas in python

[RouvenPankrath]

This Issue is about this section of a course: https://datacarpentry.org/python-socialsci/08-Pandas/index.html

In detail: When importing a csv-file with this function, it is necessary to ensure, that the csv file is encoded with UTF-8. Most of the time, when working with csv-files, e.g. with Microsoft Excel, they are stored as a csv, but not UTF-8 compatible.

I had a hard time after my first instructions on how to handle this problem. The solution is fairly simple, but one have to know about: Saving (e.g. with excel) the csv-document and changing ist to te respected type.

I would suggest giving this hint on a course to enable participants in dealing with their own files.

Instructions

Thanks for contributing! :heart:

If this contribution is for instructor training, please email the link to this contribution to [email protected] so we can record your progress. You've completed your contribution step for instructor checkout by submitting this contribution!

If this issue is about a specific episode within a lesson, please provide its link or filename.

Keep in mind that lesson maintainers are volunteers and it may take them some time to respond to your contribution. Although not all contributions can be incorporated into the lesson materials, we appreciate your time and effort to improve the curriculum. If you have any questions about the lesson maintenance process or would like to volunteer your time as a contribution reviewer, please contact The Carpentries Team at [email protected].

You may delete these instructions from your comment.

- The Carpentries