Mathew K Analytics

📊 Dataset · XLSX

lookups_whatif.xlsx dataset

Download lookups_whatif.xlsx free (9 rows × 9 columns, 50.7 KB). Preview the rows and columns, load it in pandas in one line and practise with 1 Python…

Preview (first rows)

Office supplies price list and ordersUnnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8
CodeProductCategoryPriceOrderCustomerCodeQty
P101Notebook A4Paper4.51001Bayside DentalP10410
P102Gel Pens (box)Writing12.51002Koala AccountingP1023
P103StaplerDesk18.91003Bayside DentalP1062
P104Printer Paper (ream)Paper7.81004Harbour LegalP10125
P105Highlighters (pack)Writing6.41005Koala AccountingP1056
P106Desk LampDesk391006Harbour LegalP1034

Columns

ColumnTypeMissingExample
Office supplies price list and orderstext1Code
Unnamed: 1text1Product
Unnamed: 2text1Category
Unnamed: 3text1Price
Unnamed: 4decimal9
Unnamed: 5text2Order
Unnamed: 6text2Customer
Unnamed: 7text2Code
Unnamed: 8text2Qty

Load it in Python

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