Load data

Load data from external sources into the main dataframe

From files

Df.load_csv(url, **kwargs)

Loads csv data in the main dataframe

Parameters:
  • url (str) – url of the csv file to load: can be absolute if it starts with / or relative if it starts with ./
  • kwargs – keyword arguments to pass to Pandas read_csv function
Example:

ds.load_csv("./myfile.csv")
Df.load_excel(filepath, **kwargs)

Set the main dataframe with the content of an Excel file

Parameters:
  • filepath (str) – url of the csv file to load, can be absolute if it starts with / or relative if it starts with ./
  • kwargs – keyword arguments to pass to Pandas read_excel function
Example:

ds.load_excel("./myfile.xlsx")
Df.load_h5(filepath)

Load a Hdf5 file to the main dataframe

Parameters:filepath (str) – url of the csv file to load, can be absolute if it starts with / or relative if it starts with ./
Example:ds.load_h5("./myfile.hdf5")
Df.load_json(path, **kwargs)

Load data in the main dataframe from json

Parameters:
  • filepath (str) – url of the csv file to load, can be absolute if it starts with / or relative if it starts with ./
  • kwargs – keyword arguments to pass to Pandas read_json function
Example:

ds.load_json("./myfile.json")

From a database

See the database operations section