3.3. Read Excel

• File paths works also with URLs

3.3.1. SetUp

>>> import pandas as pd

3.3.2. Parameters

• io

• sheet_name

• header

• index_col

3.3.3. Use Case - 1

>>> import pandas as pd
>>>
>>>
>>> DATA = 'https://python3.info/_static/astro-trl.xlsx'
>>>
>>> df = pd.read_excel(
...     io=DATA,
...     sheet_name='Polish',
...     header=1,
...     index_col=0)

3.3.4. Use Case - 2

>>> import pandas as pd
>>>
>>>
>>> DATA = 'https://python3.info/_static/aatc-mission-exp12.xlsx'
>>>
>>> df = pd.read_excel(
...     io=DATA,
...     sheet_name='Luminance',
...     header=1,
...     parse_dates=['datetime', 'date', 'time'],
...     index_col='datetime')