python-pandasHow to export dataframe to CSV

Usage example

import pandas as pd

df = pd.DataFrame(
  {
    "A": 1.0,
    "B": pd.Timestamp("20220102"),
    "C": pd.Series(1, index=list(range(4)), dtype="float32"),
    "E": pd.Categorical(["test", "first", "test", "second"]),
    "F": "foo"
  }
)

df.to_csv('/tmp/data.csv')

with open('/tmp/data.csv', 'r') as f:
  print(f.read())

output

,A,B,C,E,F
0,1.0,2022-01-02,1.0,test,foo
1,1.0,2022-01-02,1.0,first,foo
2,1.0,2022-01-02,1.0,test,foo
3,1.0,2022-01-02,1.0,second,foo