📊 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…
- Size50.7 KB
- Rows9
- Columns9
- Used in1 lesson
Preview (first rows)
| Office supplies price list and orders | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 |
|---|---|---|---|---|---|---|---|---|
| Code | Product | Category | Price | Order | Customer | Code | Qty | |
| P101 | Notebook A4 | Paper | 4.5 | 1001 | Bayside Dental | P104 | 10 | |
| P102 | Gel Pens (box) | Writing | 12.5 | 1002 | Koala Accounting | P102 | 3 | |
| P103 | Stapler | Desk | 18.9 | 1003 | Bayside Dental | P106 | 2 | |
| P104 | Printer Paper (ream) | Paper | 7.8 | 1004 | Harbour Legal | P101 | 25 | |
| P105 | Highlighters (pack) | Writing | 6.4 | 1005 | Koala Accounting | P105 | 6 | |
| P106 | Desk Lamp | Desk | 39 | 1006 | Harbour Legal | P103 | 4 |
Columns
| Column | Type | Missing | Example |
|---|---|---|---|
Office supplies price list and orders | text | 1 | Code |
Unnamed: 1 | text | 1 | Product |
Unnamed: 2 | text | 1 | Category |
Unnamed: 3 | text | 1 | Price |
Unnamed: 4 | decimal | 9 | |
Unnamed: 5 | text | 2 | Order |
Unnamed: 6 | text | 2 | Customer |
Unnamed: 7 | text | 2 | Code |
Unnamed: 8 | text | 2 | Qty |
Load it in Python
import pandas as pd
df = pd.read_excel("lookups_whatif.xlsx")
df.head()
