Import/Export Data

PyPI: pip install pandas

CSV Import

dtypes:

    • Dates: 'datetime64'

    • Categorical: 'category'

    • Integer: 'Int64'

    • Boolean: 'boolean'

Pandas: Additional options and information


CSV Export

sep: delimiter

na_rep: Fill missing data

Pandas: Additional options and information


Excel Import

dtypes:

    • Dates: 'datetime64'

    • Categorical: 'category'

    • Integer: 'Int64'

    • Boolean: 'boolean'

Pandas: Additional options and information


Excel Export

sheet_name: str; name of excel sheet

na_rep: filling for missing data

Pandas: Additional options and information