# The following short CSV file called "mammals.csv" is parsed # in the code below. It must be in the project's "data" folder. # # id,species,name # 0,Capra hircus,Goat # 1,Panthera pardus,Leopard # 2,Equus zebra,Zebra table = loadTable("mammals.csv", "header") print("%i total rows in table" % (table.getRowCount())) for row in table.rows(): mammal_id = row.getInt("id") species = row.getString("species") name = row.getString("name") print(name + " (" + species + ") has an ID of " + str(mammal_id)) # Sketch prints: # 3 total rows in table # Goat (Capra hircus) has an ID of 0 # Leopard (Panthera pardus) has an ID of 1 # Zebra (Equus zebra) has an ID of 2
Reads the contents of a file or URL and creates an Table object with its values. If a file is specified, it must be located in the sketch's "data" folder. The filename parameter can also be a URL to a file found online. By default, the file is assumed to be comma-separated (in CSV format). To use tab-separated data, include "tsv" in the options parameter.
If the file contains a header row, include "header" in the options parameter. If the file does not have a header row, then simply omit the "header" option.
When specifying both a header and the file type, separate the options with commas, as in: loadTable("data.csv", "header, tsv")
All files loaded and saved by the Processing API use UTF-8 encoding.
loadTable(filename) loadTable(filename, options)
Updated on Mon Sep 21 15:53:25 2020.
If you see any errors or have comments, please let us know.
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License