This notebook does not use Tatoeba data. Instead, it provides some functions that you may want to use in other notebooks. You can check how to:

Run the following cell to be able to run the examples.

In [ ]:
import pandas as pd


# Write a dataframe into a file that can be retrieved¶

It is very simple to write a dataframe to a CSV file.

Suppose you have the following dataframe

In [ ]:
df = pd.DataFrame({'name': ['Raphael', 'Donatello'],
'weapon': ['sai', 'bo staff']})
df


You can use the to_csv function to write your dataframe to a CSV file. If you have some Python knowledge, you can check the documentation. Otherwise, the following examples are the most used.

After running the to_csv function, go back to the Home page. All files in the current folder are displayed there, so you should see your Data_export.csv file. If you want to download it, simply check the box on its left and click the Download button at the top of the list.

### 1. Write everything¶

Simply specify the name of the file you want to create.

In [ ]:
df.to_csv('Data_export.csv')


This will give you the following content

In [ ]:
!cat 'Data_export.csv'


### 2. Do not write the index¶

The index of a dataframe is the first column on the left (in bold). In some situations, it is a useless information so you can ignore it when you export your data to a file. To do so, add the index=False parameter.

In [ ]:
df.to_csv('Data_export.csv', index=False)


This will give you the following content

In [ ]:
!cat 'Data_export.csv'


### 3. Do not write the headers¶

If you don't need the column headers, add the header=None parameter.

In [ ]:
df.to_csv('Data_export.csv', index=False, header=None)


This will give you the following content

In [ ]:
!cat 'Data_export.csv'


### 4. Change the separator¶

The default separator is the comma , (hence, CSV :) ). If you want to change it, you can use sep='<character>'. Note: a tabulation is represented by \t.

In [ ]:
df.to_csv('Data_export.csv', index=False, header=None, sep='\t')


This will give you the following content

In [ ]:
!cat 'Data_export.csv'