DataFrame.toCSV
Convert DataFrame to a comma-separated values (CSV)
Deprecated in v1.1.0: Use the dfd.toCSV
function directly instead
DataFrame.toCSV(options)
Parameters
Type
Description
Default
options
object, optional
Configuration object:
filePath
: Local file path to write the CSV file to. If not specified, the CSV will be returned as a string. Only needed in Nodejs version
fileName
: The name of the file to download as. Only needed in browser environment.
download
: Boolean indicating whether to automatically download the CSV file in the browser. Only needed in the browser environment.
header
: Boolean indicating whether to include a header row in the CSV file.
sep
: Character to be used as a separator in the CSV file.
{ sep: "," }
The toCSV function can be used to write out a DataFrame or Series to CSV file. The output is configurable and will depend on the environment. In the following examples, we show you how to write/download a CSV file from Node and Browser environments.
Convert DataFrame to CSV string and return value
const dfd = require("danfojs-node")
let data = {
Abs: [20.2, 30, 47.3],
Count: [34, 4, 5],
"country code": ["NG", "FR", "GH"],
};
let df = new dfd.DataFrame(data);
const csv = df.toCSV();
console.log(csv);
//output
Abs,Count,country code
20.2,34,NG
30,4,FR
47.3,5,GH
Convert DataFrame to CSV and write to local file path
Writing a CSV file to a local file path is only supported in the Nodejs environment
const dfd = require("danfojs-node")
let data = {
Abs: [20.2, 30, 47.3],
Count: [34, 4, 5],
"country code": ["NG", "FR", "GH"],
};
let df = new dfd.DataFrame(data);
df.toCSV({ filePath: "testOut.csv"});
Convert DataFrame to CSV and download file in browser
You can automatically convert and download a CSV file in a browser environment, by specifying a fileName
and setting download
to true.
let data = {
Abs: [20.2, 30, 47.3],
Count: [34, 4, 5],
"country code": ["NG", "FR", "GH"],
};
let df = new dfd.DataFrame(data);
df.toCSV({ fileName: "testOut.csv", download: true});
Last updated
Was this helpful?