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_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_parquet()
... 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