Input/output

Flat file

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

Read a comma-separated values (csv) file into 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.