Pandas video: Pandas Topic

Inside this chapter, we will learn what is Series and DataFrame.

  • Series  – One-dimension ndarray with axis labels
  • DataFrame  – Two-dimension size mutable, potentially heterogeneous tabular data structure with labelled axes (rows and columns)

Pandas IO (Input & Output)

Format Type Data Description Reader Writer
Text CSV read_csv to_csv
Text JSON read_json to_json
Text HTML read_html to_html
Text Local Clipboard read_clipboard to_clipboard
Binary MS Excel read_excel to_excel
SQL SQL read_sql to_sql
SQL Google BigQuery read_gbq to_gbq

Documentation for Pandas: Pandas Documentation