Pandas Excel: Difference between revisions
Jump to navigation
Jump to search
(Created page with "=Internal= * Pandas Concepts =Overview= =Procedure= Install openpyxl: <syntaxhighlight lang='bash'> pip3 install openpyxl </syntaxhighlight> <sy...") |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
=External= | |||
* https://pandas.pydata.org/docs/reference/api/pandas.read_excel.html | |||
=Internal= | =Internal= | ||
* [[Pandas_Concepts#Excel|Pandas Concepts]] | * [[Pandas_Concepts#Excel|Pandas Concepts]] | ||
=Procedure= | =Procedure= | ||
| Line 13: | Line 13: | ||
<syntaxhighlight lang='py'> | <syntaxhighlight lang='py'> | ||
df = pd.DataFrame(pd.read_excel( | df = pd.DataFrame(pd.read_excel('./some_file.xlsx', parse_dates=["Date"])) | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Latest revision as of 03:16, 31 October 2023
External
Internal
Procedure
Install openpyxl:
pip3 install openpyxl
df = pd.DataFrame(pd.read_excel('./some_file.xlsx', parse_dates=["Date"]))