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