Дана таблица (словарь) с пропущенными значениями (None).
Заполните пропуски:
- Числовые колонки — медианой колонки
- Строковые колонки — модой (самым частым значением) колонки
def fill_missing(data: dict) -> list[dict]:
data = {"name": ["Alice","Bob","Charlie","Alice"], "age": [25,None,30,28], "city": ["Moscow","Moscow",None,"SPb"]}
fill_missing(data) → [
{"name": "Alice", "age": 25, "city": "Moscow"},
{"name": "Bob", "age": 28, "city": "Moscow"},
{"name": "Charlie", "age": 30, "city": "Moscow"},
{"name": "Alice", "age": 28, "city": "SPb"}
]
Объяснение: age: median([25,30,28]) = 28. city: mode = Moscow (2 раза).
Числа возвращать как int если они целые.
data = {"name":["Alice","Bob","Charlie","Alice"],"age":[25,null,30,28],"city":["Moscow","Moscow",null,"SPb"]}[{"name":"Alice","age":28,"city":"Moscow"},{"name":"Bob","age":28,"city":"Moscow"},{"name":"Charlie","age":30,"city":"Moscow"},{"name":"Alice","age":28,"city":"SPb"}]age median=28, city mode=Moscow
data = {"x":["a",null,"a","b"],"y":[1,2,null,3]}[{"x":"a","y":1},{"x":"a","y":2},{"x":"a","y":2},{"x":"b","y":3}]y median=2, x mode=a