📊 Dataset · XLSX
excel107_finance.xlsx dataset
Download excel107_finance.xlsx free (13 rows × 7 columns, 48.4 KB). Preview the rows and columns, load it in pandas in one line and practise with 1 Python…
- Size48.4 KB
- Rows13
- Columns7
- Used in1 lesson
Preview (first rows)
| The time value of money | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 |
|---|---|---|---|---|---|---|
| Year | Simple | Compound | Interest rate | 0.05 | ||
| 0 | 1000 | 1000 | ||||
| 1 | 1050 | 1050 | Rule of 72 | 14.4 | ||
| 2 | 1100 | 1102.5 | Exact years | 14.206699082890461 | ||
| 3 | 1150 | 1157.625 | ||||
| 4 | 1200 | 1215.5062500000001 | FV of 1000 | 1628.8946267774415 | ||
| 5 | 1250 | 1276.2815625000003 | Without the minus | -1628.8946267774415 |
Columns
| Column | Type | Missing | Example |
|---|---|---|---|
The time value of money | text | 1 | Year |
Unnamed: 1 | text | 1 | Simple |
Unnamed: 2 | text | 1 | Compound |
Unnamed: 3 | decimal | 13 | |
Unnamed: 4 | decimal | 13 | |
Unnamed: 5 | text | 8 | Interest rate |
Unnamed: 6 | decimal | 8 | 0.05 |
Load it in Python
import pandas as pd
df = pd.read_excel("excel107_finance.xlsx")
df.head()
