📊 Dataset · XLSX
excel110_templates.xlsx dataset
Download excel110_templates.xlsx free (14 rows × 4 columns, 30.0 KB). Preview the rows and columns, load it in pandas in one line and practise with 1 Python…
- Size30.0 KB
- Rows14
- Columns4
- Used in1 lesson
Preview (first rows)
| Custom number formats | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 |
|---|---|---|---|
| Value | Shown as | Format code | Used for |
| 72.456 | 72.456 | 0.0"kg" | Weight with a unit |
| 1234567 | 1234567 | #,##0 | Thousands separators |
| -1520.5 | -1520.5 | "$"#,##0.00;[Red]-"$"#,##0.00 | Money, negatives in red |
| 2026-11-03 00:00:00 | 2026-11-03 00:00:00 | dd-mmm-yyyy | Dates |
| 800 | 800 | 0000 | Postcodes |
| 42 | 42 | 00000 | Staff IDs |
Columns
| Column | Type | Missing | Example |
|---|---|---|---|
Custom number formats | text | 2 | Value |
Unnamed: 1 | text | 4 | Shown as |
Unnamed: 2 | text | 4 | Format code |
Unnamed: 3 | text | 4 | Used for |
Load it in Python
import pandas as pd
df = pd.read_excel("excel110_templates.xlsx")
df.head()
