3.1. Read About

../../_images/pandas-about-workflow1.png

3.1.1. SetUp

>>> import pandas as pd
>>>
>>> pd.set_option('display.max_columns', 50)
>>> pd.set_option('display.max_rows', 200)
>>> pd.set_option('display.width', 500)
>>> pd.set_option('display.memory_usage', 'deep')
>>> pd.set_option('display.precision', 4)

3.1.2. Most Frequently Used

  • pd.read_csv()

  • pd.read_excel()

  • pd.read_html()

  • pd.read_json()

  • pd.read_parquet()

  • pd.read_sql()

3.1.3. Others

  • pd.read_clipboard()

  • pd.read_feather()

  • pd.read_fwf()

  • pd.read_gbq()

  • pd.read_hdf()

  • pd.read_msgpack()

  • pd.read_pickle()

  • pd.read_sas()

  • pd.read_spss()

  • pd.read_sql_query() - Read SQL query into a DataFrame

  • pd.read_sql_table() - Read SQL database table into a DataFrame

  • pd.read_stata()

  • pd.read_table()

  • pd.read_xml()

3.1.4. PDF