我是 python 和一般編程的新手。我希望下面的問(wèn)題得到很好的解釋。我有一個(gè)很大的數(shù)據(jù)集，有 80 多列，其中一些列只有每周的數(shù)據(jù)。我想將這些列轉(zhuǎn)換為每天的值，只需將每周值除以 7 并將結(jié)果歸因于值本身和該周的其他 6 天。這是我的輸入數(shù)據(jù)集的樣子： date col1 col2 col302-09-2019 14 NaN 109-09-2019 NaN NaN 216-09-2019 NaN 7 323-09-2019 NaN NaN 430-09-2019 NaN NaN 507-10-2019 NaN NaN 614-10-2019 NaN NaN 721-10-2019 21 NaN 828-10-2019 NaN NaN 904-11-2019 NaN 14 1011-11-2019 NaN NaN 11..輸出應(yīng)如下所示： date col1 col2 col302-09-2019 2 NaN 109-09-2019 2 NaN 216-09-2019 2 1 323-09-2019 2 1 430-09-2019 2 1 507-10-2019 2 1 614-10-2019 2 1 721-10-2019 3 1 828-10-2019 3 1 904-11-2019 3 2 10 11-11-2019 3 2 11..我無(wú)法想出解決方案，但我認(rèn)為這可能有效：def convert_to_daily(df): for column in df.columns.tolist(): if column.isna(): # if true for line in range(len(df[column])): # check if value is not empty and succeeded by an 6 empty values or some better logic # I don′t know how to do that.
如何使用 Python 將特定列的每周數(shù)據(jù)轉(zhuǎn)換為每日數(shù)據(jù)
千萬(wàn)里不及你
2023-09-05 15:32:45
