📊 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…
- Size50.6 KB
- Rows8
- Columns10
- Used in1 lesson
Preview (first rows)
| Office supplies order | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 |
|---|---|---|---|---|---|---|---|---|---|
| Item | Price | Qty | Line total | One formula | Spilled | Big orders | |||
| Notebook | 4.5 | 12 | 328 | 54 | Notebook | ||||
| Pen | 1.2 | 40 | 48 | Folder | |||||
| Stapler | 15 | 3 | 45 | Marker | |||||
| Folder | 2.8 | 25 | 70 | ||||||
| Marker | 3.5 | 18 | 63 | ||||||
| Calculator | 24 | 2 | 48 |
Columns
| Column | Type | Missing | Example |
|---|---|---|---|
Office supplies order | text | 1 | Item |
Unnamed: 1 | text | 1 | Price |
Unnamed: 2 | text | 1 | Qty |
Unnamed: 3 | text | 7 | Line total |
Unnamed: 4 | decimal | 8 | |
Unnamed: 5 | text | 6 | One formula |
Unnamed: 6 | decimal | 8 | |
Unnamed: 7 | text | 1 | Spilled |
Unnamed: 8 | decimal | 8 | |
Unnamed: 9 | text | 4 | Big orders |
Load it in Python
import pandas as pd
df = pd.read_excel("advanced_excel.xlsx")
df.head()
