📊 Dataset · XLSX
formulas_functions.xlsx dataset
Download formulas_functions.xlsx free (8 rows × 6 columns, 32.2 KB). Preview the rows and columns, load it in pandas in one line and practise with 1 Python…
- Size32.2 KB
- Rows8
- Columns6
- Used in1 lesson
Preview (first rows)
| How functions work | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 |
|---|---|---|---|---|---|
| Item | Price | Qty | Total qty | 90.0 | |
| Notebook | 4.85 | 12 | Average price | 4.286 | |
| Pens | 1.35 | 40 | Rounded average | 4.29 | |
| Stapler | 8.99 | 3 | Order value | 238.32 | |
| Folder | 2.45 | 25 | Price range | 7.640000000000001 | |
| Marker | 3.79 | 10 | Prices counted | 5.0 | |
| Pi | 3.141592653589793 |
Columns
| Column | Type | Missing | Example |
|---|---|---|---|
How functions work | text | 2 | Item |
Unnamed: 1 | text | 2 | Price |
Unnamed: 2 | text | 2 | Qty |
Unnamed: 3 | decimal | 8 | |
Unnamed: 4 | text | 1 | Total qty |
Unnamed: 5 | decimal | 1 | 90.0 |
Load it in Python
import pandas as pd
df = pd.read_excel("formulas_functions.xlsx")
df.head()
