CSV cheat sheet

This cheat sheet shows common ways to read and write CSV files with read_csv and write_csv. The examples write files to /data, the data directory in Deephaven's Docker images, and read them back from there or from a URL. To map it to a directory on your computer, see Docker bind mounts. In other deployments, use any path the server can read and write.

Create a table

The examples on this page write and read this sample table. Its SinX column is null in every other row, so the write examples can show how null cells are written.

Write CSV files

write_csv writes a table, or the columns you list, to a CSV file on the server.

Read CSV files

read_csv reads a CSV file from a server path or a URL. Options handle files with no header row and other delimiters.