Input/output

Flat file

read_csv(path[, names, sep, index_col, ...])

Read a comma-separated values (csv) file into DataFrame.

Parquet

read_parquet(path[, engine, columns, ...])

Load a parquet object from the file path, returning a DataFrame.

SQL

read_sql(sql, con[, index_col, ...])	Read SQL query or database table into a DataFrame.
read_sql_table(table_name, con[, schema, ...])	Read SQL database table into a DataFrame.
read_sql_query(sql, con[, index_col, ...])	Read SQL query into a DataFrame.