Pandas Excel: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
(Created page with "=Internal= * Pandas Concepts =Overview= =Procedure= Install openpyxl: <syntaxhighlight lang='bash'> pip3 install openpyxl </syntaxhighlight> <sy...")
 
Line 13: Line 13:


<syntaxhighlight lang='py'>
<syntaxhighlight lang='py'>
df = pd.DataFrame(pd.read_excel("./some.xlsx"))  
df = pd.DataFrame(pd.read_excel('./some_file.xlsx', parse_dates=["Date"]))  
</syntaxhighlight>
</syntaxhighlight>

Revision as of 03:06, 31 October 2023

Internal

Overview

Procedure

Install openpyxl:

pip3 install openpyxl
df = pd.DataFrame(pd.read_excel('./some_file.xlsx', parse_dates=["Date"]))