Mathew K Analytics

📊 Dataset · XLSX

tables_cleaning.xlsx dataset

Download tables_cleaning.xlsx free (42 rows × 7 columns, 42.9 KB). Preview the rows and columns, load it in pandas in one line and practise with 1 Python…

Preview (first rows)

Orders, January to March 2026Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6
Order IDDateCustomerRegionProductQtyUnit Price
10012026-01-07 00:00:00Riverbend SchoolNorthMonitor14320
10022026-01-08 00:00:00Wattle AccountingNorthKeyboard585
10032026-01-10 00:00:00Coastal PhysioWestLaptop11450
10042026-01-11 00:00:00Outback FreightWestMonitor4320
10052026-01-12 00:00:00Southern Cross DentalNorthKeyboard585
10062026-01-15 00:00:00Harbour CafeSouthLaptop21450

Columns

ColumnTypeMissingExample
Orders, January to March 2026text1Order ID
Unnamed: 1text1Date
Unnamed: 2text1Customer
Unnamed: 3text1Region
Unnamed: 4text1Product
Unnamed: 5text1Qty
Unnamed: 6text1Unit Price

Load it in Python

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