Skip to content

Instantly share code, notes, and snippets.

@messefor

messefor/excel_pandas.md

Last active December 4, 2016 11:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save messefor/9373a8def4734bf3deffc1366ac732ed to your computer and use it in GitHub Desktop.
Save messefor/9373a8def4734bf3deffc1366ac732ed to your computer and use it in GitHub Desktop.
Download ZIP
Excel Bookからデータをpandasに読み込むメモ
Raw
excel_pandas.md

pandas Excel Bookからデータ読み込み

anaconda が入っていれば、特に問題にならない

  • openpyxl, xlrd/xlwt openpyxl version 1.6.1 or higher, but lower than 2.0.0 Needed for Excel I/O

  • Excel Book からロード

    import pandas as pd

df = pd.read_excel('excel_book.xlsx', sheetname=0, index_col=0)

    pandas.read_excel(io, sheetname=0, header=0, skiprows=None, skip_footer=0, index_col=None, names=None, parse_cols=None, parse_dates=False, date_parser=None, na_values=None, thousands=None, convert_float=True, has_index_names=None, converters=None, true_values=None, false_values=None, engine=None, squeeze=False, **kwds)[source]

    pandas.read_excel

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment