JIYIK CN >

This tutorial explains how we can use pandas.DataFrame.to_csv()the function to write a DataFrame to a CSV file. pandas.DataFrame.to_csv()The function writes the elements of a DataFrame to a CSV file.

pandas.DataFrame.to_csv()Function syntax

pandas.DataFrame.to_csv(
    path_or_buf=None,
    sep=",",
    na_rep="",
    float_format=None,
    columns=None,
    header=True,
    index=True,
    index_label=None,
    mode="w",
    encoding=None,
    compression="infer",
    quoting=None,
    quotechar='""',
    line_terminator=None,
    chunksize=None,
    date_format=None,
    doublequote=True,
    escapechar=None,
    decimal=".",
)

Use pandas.DataFrame.to_csv()the function to write the DataFrame to a CSV file

import pandas as pd

mid_term_marks = {
    "Student": ["Kamal", "Arun", "David", "Thomas", "Steven"],
    "Economics": [10, 8, 6, 5, 8],
    "Fine Arts": [7, 8, 5, 9, 6],
    "Mathematics": [7, 3, 5, 8, 5],
}


mid_term_marks_df = pd.DataFrame(mid_term_marks)

print(mid_term_marks_df)

Output:

  Student  Economics  Fine Arts  Mathematics
0   Kamal         10          7            7
1    Arun          8          8            3
2   David          6          5            5
3  Thomas          5          9            8
4  Steven          8          6            5

We will then mid_term_marks_dfwrite the DataFrame to a CSV file.

import pandas as pd

mid_term_marks = {
    "Student": ["Kamal", "Arun", "David", "Thomas", "Steven"],
    "Economics": [10, 8, 6, 5, 8],
    "Fine Arts": [7, 8, 5, 9, 6],
    "Mathematics": [7, 3, 5, 8, 5],
}


mid_term_marks_df = pd.DataFrame(mid_term_marks)

mid_term_marks_df.to_csv("midterm.csv")

It will create a midterm.csvfile named and write the values ​​of the DataFrame to that file, with adjacent rows of values ,​​separated by commas .

midterm.csvThe content of the file will be.

,Student,Economics,Fine Arts,Mathematics
0,Kamal,10,7,7
1,Arun,8,8,3
2,David,6,5,5
3,Thomas,5,9,8
4,Steven,8,6,5

By default, pandas.DataFrame.to_csv()the function will also write the DataFrame's index to the CSV, but the index may not always be useful in all cases.

Use pandas.DataFrame.to_csv()the function to write a DataFrame to a CSV file and ignore the index

To ignore the index, we can pandas.DataFrame.to_csv()set it in the function index=False.

import pandas as pd

mid_term_marks = {
    "Student": ["Kamal", "Arun", "David", "Thomas", "Steven"],
    "Economics": [10, 8, 6, 5, 8],
    "Fine Arts": [7, 8, 5, 9, 6],
    "Mathematics": [7, 3, 5, 8, 5],
}


mid_term_marks_df = pd.DataFrame(mid_term_marks)

mid_term_marks_df.to_csv("midterm.csv", index=False)

In this case midterm.csvthe contents of the file will be.

Student,Economics,Fine Arts,Mathematics
Kamal,10,7,7
Arun,8,8,3
David,6,5,5
Thomas,5,9,8
Steven,8,6,5

Sometimes, when we write the contents of a DataFrame to a CSV file, this may happen UnicodeEncodeError. In this case, we can set encoding='utf-8'and enable utf-8the encoding format.

pandas.DataFrame.to_csv()Specify a delimiter in the function

By default, when writing a DataFrame to a CSV file, the values ​​are separated by commas. If we want to use a different separator, we can sepspecify it using the comma separator parameter.

import pandas as pd

mid_term_marks = {
    "Student": ["Kamal", "Arun", "David", "Thomas", "Steven"],
    "Economics": [10, 8, 6, 5, 8],
    "Fine Arts": [7, 8, 5, 9, 6],
    "Mathematics": [7, 3, 5, 8, 5],
}


mid_term_marks_df = pd.DataFrame(mid_term_marks)

mid_term_marks_df.to_csv("midterm.csv", index=False, sep="\t")

In this case midterm.csvthe contents of the file will be.

Student Economics Fine Arts Mathematics
Kamal 10  7 7
Arun  8 8 3
David 6 5 5
Thomas  5 9 8
Steven  8 6 5

Here the values ​​are separated by tabs.