Mathew K Analytics

📊 Dataset · XLSX

advanced_excel.xlsx dataset

Download advanced_excel.xlsx free (8 rows × 10 columns, 50.6 KB). Preview the rows and columns, load it in pandas in one line and practise with 1 Python…

Preview (first rows)

Office supplies orderUnnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9
ItemPriceQtyLine totalOne formulaSpilledBig orders
Notebook4.51232854Notebook
Pen1.24048Folder
Stapler15345Marker
Folder2.82570
Marker3.51863
Calculator24248

Columns

ColumnTypeMissingExample
Office supplies ordertext1Item
Unnamed: 1text1Price
Unnamed: 2text1Qty
Unnamed: 3text7Line total
Unnamed: 4decimal8
Unnamed: 5text6One formula
Unnamed: 6decimal8
Unnamed: 7text1Spilled
Unnamed: 8decimal8
Unnamed: 9text4Big orders

Load it in Python

import pandas as pd
df = pd.read_excel("advanced_excel.xlsx")
df.head()