Comment on page
danfo.readCSV
Reads a comma-separated values (CSV) file into DataFrame. Also supports the reading of CSV files in chunks.
danfo.readCSV(source, options)
Parameters | Type | Description | Default |
source | File object, File path, URL | Any valid string path is acceptable. The string could be a URL or a valid local file path. | |
options | object, optional | { header: true } |
The readCSV method can read a CSV file from a local disk, or over the internet (URL). Reading of local files is only supported in Nodejs, while reading of input file objects is only supported in the browser.
By specifying a valid file path, you can load CSV files from local disk:
Node.js
const dfd = require("danfojs-node")
dfd.readCSV("./user_names.csv") //assumes file is in CWD
.then(df => {
df.head().print()
}).catch(err=>{
console.log(err);
})
By specifying a valid URL, you can load CSV files from any location into Danfo**'**s data structure:
Node.js
Browser
const dfd = require("danfojs-node")
dfd.readCSV("https://raw.githubusercontent.com/plotly/datasets/master/finance-charts-apple.csv") //assumes file is in CWD
.then(df => {
df.head().print()
}).catch(err=>{
console.log(err);
})
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<script src="https://cdn.plot.ly/plotly-2.2.0.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/lib/bundle.min.js"></script>
<title>Document</title>
</head>
<body>
<div id="plot_div"></div>
<script>
dfd.readCSV("https://raw.githubusercontent.com/plotly/datasets/master/finance-charts-apple.csv")
.then(df => {
//do something like display descriptive statistics
df.describe().print()
}).catch(err => {
console.log(err);
})
</script>
</body>
</html>
Browser
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<script src="https://cdn.jsdelivr.net/npm/[email protected]/lib/bundle.min.js"></script>
<title>Document</title>
</head>
<body>
<input type="file" id="file" name="file">
<script>
inputFile.addEventListener("change", async () => {
const csvFile = inputFile.files[0]
dfd.readCSV(csvFile).then((df) => {
df.print()
})
})
</script>
</body>
</html>
Last modified 1yr ago