In this python pandas programming tutorial, we will go over a few ways to import, export and create data sets. We will also briefly go over how to save/export a spreadsheet (i.e. - Numbers, LibreOffice Calc) to csv or excel format.
Note: According to the pandas documentation, the sep and delimiter arguments (delimiter is an alternative argument name for sep) for read_csv() can often automatically detect the separators so if the data is in a normal csv (comma separated values) file, you probably won’t need the delimiter or sep arguments. It appears to work either way (i.e.-with no delimiter or delimiter=',').