时间戳

首页 > 解决方案 > 用中位数填充熊猫数据框中的第一个日期到最后一个日期的行

python-3.x - 用中位数填充熊猫数据框中的第一个日期到最后一个日期的行

问题描述

大家好，我有一个从日期 2019-10-03 开始​​到 2019-10-28 结束的数据框。我想要日期为 2019-10-01 到 2019-10-31 的数据框。最后一列部分填充了当前数据框的最后一列中位数。需要正确的方法来做到这一点。

indexDate                                                                                                    
2019-10-03 2019-10-03     NEFT-LB3670191003Z508-MR PRASAD GEETHA- BAD...   deposit  103300.0         476853.6
2019-10-04 2019-10-04     NEFT-N277190945376455-FINSHERPA INVESTMENT-...   deposit  103300.0         779542.6
2019-10-05 2019-10-05    NEFT-SAA68109135-THE METAL POWDER COMPANY- L...   deposit   39400.0         349057.6
2019-10-06 2019-10-05    NEFT-SAA68109135-THE METAL POWDER COMPANY- L...   deposit   39400.0         349057.6
2019-10-07 2019-10-07     NEFT-N280190947374122-PRAVIN L RAJENDRAN-PR...   deposit  103019.0         452076.6
2019-10-08 2019-10-07     NEFT-N280190947374122-PRAVIN L RAJENDRAN-PR...   deposit  103019.0         452076.6
2019-10-09 2019-10-09    NEFT-PUNBH19282586104-BHARATH LAJHNA MULTI- ...   deposit   40000.0         230377.6
2019-10-10 2019-10-10     MMT/IMPS/928316107218/Japan visa/M CHARLES ...   deposit    9200.0         264279.6
2019-10-11 2019-10-11     NEFT-N284190952298833-MADRAS TALKIESPROJECT...   deposit   19885.0         358396.6
2019-10-12 2019-10-11     NEFT-N284190952298833-MADRAS TALKIESPROJECT...   deposit   19885.0         358396.6
2019-10-13 2019-10-11     NEFT-N284190952298833-MADRAS TALKIESPROJECT...   deposit   19885.0         358396.6
2019-10-14 2019-10-14     RTGS:ICICR52019101400532057/TMBL0000165/FLY...  withdraw  200000.0         158396.6
2019-10-15 2019-10-15     MMT/IMPS/928816129663/Refund of exces/SKS- ...   deposit    1180.0         175076.6
2019-10-16 2019-10-16     NEFT-MSNUH19289000695-AMIT ACETYLENE PVT LT...   deposit   32700.0         207776.6
2019-10-17 2019-10-17           26482 TRFR TO: HERMES I TICKETS PVT LTD   withdraw  200000.0         161076.6
2019-10-18 2019-10-18              26485 TRFR TO:CHOICE TRAVEL SERVICES   withdraw   13653.0         408006.6
2019-10-19 2019-10-19           26486 TRFR TO: HERMES I TICKETS PVT LTD   withdraw  190000.0         276772.6
2019-10-20 2019-10-19           26486 TRFR TO: HERMES I TICKETS PVT LTD   withdraw  190000.0         276772.6
2019-10-21 2019-10-21    NEFT-PUNBH19294588987-BHARATH LAJHNA MULTI- ...   deposit   50000.0         216772.6
2019-10-22 2019-10-22    BIL/INFT/001828963217/Australia Tkts/ NARASI...   deposit   56400.0         226972.6
2019-10-23 2019-10-23           26489 TRFR TO: HERMES I TICKETS PVT LTD   withdraw  125000.0         437396.6
2019-10-24 2019-10-24          - BIL/INFT/001830247383/NA/ ARULBARATH A    deposit   68346.0         220186.6
2019-10-25 2019-10-25     NEFT-N298190964842360-TIBRO TOURS PRIVATE-P...   deposit   30000.0         187486.6
2019-10-26 2019-10-25     NEFT-N298190964842360-TIBRO TOURS PRIVATE-P...   deposit   30000.0         187486.6
2019-10-27 2019-10-25     NEFT-N298190964842360-TIBRO TOURS PRIVATE-P...   deposit   30000.0         187486.6
2019-10-28 2019-10-28                    26493 TRFR TO: YESUDAS PETER S   withdraw   33457.0         154029.6

标签： python-3.xpandas

解决方案

我认为将新列计算为其他列的平均值，熊猫会回答你的问题。而不是平均值，您需要计算中位数。

这可以指导您计算中位数：https ://www.geeksforgeeks.org/python-pandas-dataframe-median/

推荐阅读