Pandas – Convert DataFrame to CSV

Pandas – Convert DataFrame to CSV String

To convert a DataFrame to CSV (Comma Separated Values) string in Pandas, call DataFrame.to_csv() function and pass the required arguments.

Syntax

The syntax to convert a DataFrame df to CSV is

df.to_csv()

By default, the index of the DataFrame is also converted to CSV. If index has to be excluded in the CSV output, then pass index=False as argument.

df.to_csv(index=False)

Examples

1. Convert given DataFrame df to a CSV string

In this example, we take a DataFrame with five rows, and convert this DataFarme to CSV using DataFrame.to_csv() function.

import pandas as pd

df = pd.DataFrame({'name':['a', 'b', 'c', 'd', 'e'],
                   'age' :[20, 21, 20, 19, 21]})
result = df.to_csv()
print(result)

Output

,name,age
0,a,20
1,b,21
2,c,20
3,d,19
4,e,21

2. Convert given DataFrame df to a CSV string by ignoring the index.

Now, let us convert the DataFrame to CSV, ignoring index. Pass index=False to the DataFrame.to_csv() method.

import pandas as pd

df = pd.DataFrame({'name':['a', 'b', 'c', 'd', 'e'],
                   'age' :[20, 21, 20, 19, 21]})
result = df.to_csv(index=False)
print(result)

Output

name,age
a,20
b,21
c,20
d,19
e,21

Summary

In this Pandas Tutorial, we learned how to convert a DataFrame to CSV String.