Mathew K Analytics

📊 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…

Preview (first rows)

How functions workUnnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5
ItemPriceQtyTotal qty90.0
Notebook4.8512Average price4.286
Pens1.3540Rounded average4.29
Stapler8.993Order value238.32
Folder2.4525Price range7.640000000000001
Marker3.7910Prices counted5.0
Pi3.141592653589793

Columns

ColumnTypeMissingExample
How functions worktext2Item
Unnamed: 1text2Price
Unnamed: 2text2Qty
Unnamed: 3decimal8
Unnamed: 4text1Total qty
Unnamed: 5decimal190.0

Load it in Python

import pandas as pd
df = pd.read_excel("formulas_functions.xlsx")
df.head()