26 lines
663 B
Plaintext
26 lines
663 B
Plaintext
= Pandas =
|
|
|
|
Pandas is the python data analysis library
|
|
|
|
== Data frames
|
|
|
|
== Spreadsheets ==
|
|
|
|
=== Open a spreadsheet ===
|
|
|
|
`myWorkbook = pandas.read_excel('./path/to/excel/file.xlsx', skiprows=7)`
|
|
|
|
This will import the provided file, and skip over the first `7` rows
|
|
|
|
`myWorkbook.head()` will display the first 5 or so rows of the spreadsheet
|
|
|
|
=== Reading from a sheet ===
|
|
|
|
To read from a sheet, we use several operations on the dataframe object returned
|
|
by `read_excel`.
|
|
|
|
`myWorkbook.iloc[0]` searches based on the index location. So in the previous
|
|
example, it returns values in the 0th index. For other reading operations,
|
|
refer to reading dataframes for pandas
|
|
|