Untitled
Anonymous
Plain Text
10/28/2025 5:41 AM
1.4 KB
19
Indexable
Never
#Aufgabe 1a
import pandas as pd
tuples = [
("Wien", "country"),
("Wien", "area"),
("Wien", "population"),
("Berlin", "country"),
("Berlin", "area"),
("Berlin", "population"),
("Zürich", "country"),
("Zürich", "area"),
("Zürich", "population"),
]
index = pd.MultiIndex.from_tuples(tuples)
df = pd.Series(
[
"Österreich", 414.6, 1805681,
"Deutschland", 891.85, 3562166,
"Schweiz", 87.88, 378884
],
index=index
)
print(df)
#Aufgabe 1b
df_sorted = df.sort_index()
print(df_sorted)
#Aufgabe 1c
df_swapped = df_sorted.swaplevel().sort_index()
print(df_swapped)
#Aufgabe 2a
import pandas as pd
data = {
"Gewicht": [65, 58, 58, 45, 43, 99, 68, 60],
"Größe": [179, 165, 172, 154, 150, 189, 176, 175]
}
df = pd.DataFrame(data, index=["Henry", "Sarah", "Elke", "Lulu", "Vera", "Toni", "Maria", "Chris"])
print(df)
#Aufgabe 2b
bmi = df["Gewicht"] / (df["Größe"]/100)**2
normalbereich = df.loc[(bmi >= 18.5) & (bmi <= 25)]
print(normalbereich)
#Aufgabe 2c
mit_e = df[df.index.str.contains("e")]
print(mit_e)
#Aufgabe 2d
df["BMI"] = df["Gewicht"] / (df["Größe"]/100)**2
print(df)
#Aufgabe 2e
df_sorted_bmi = df.sort_values("BMI", ascending=False)
print(df_sorted_bmi)
#Aufgabe 2f
unter_20_mit_e = df[(df["BMI"] < 20) & (df.index.str.contains("e"))]
print(unter_20_mit_e)Editor is loading...
Leave a Comment