Revision history [back]

The method for composing a configuration line before the headers when exporting a dataframe to CSV is to create a string with the desired configuration options using the following syntax:

config_string = "# configuration_option_1=value, configuration_option_2=value, ..."

Once the config string is created, it can be written to the CSV file before the headers:

with open('file.csv', 'w') as file:
    file.write(config_string + '\n')
    df.to_csv(file, index=False)

Here's an example of how to create a config string that sets the delimiter to semicolon, forces quotes around strings, and uses the UTF-8 encoding:

config_string = "# delimiter=;, quoting=ALL, encoding=UTF-8"