python - 每小时汇总价格和交易量 pandas python
问题描述
我需要快速帮助。如何从 1 分钟蜡烛到 1 小时重新采样此数据框中的数据我不想总结价格可能选择最高或最低,只有我需要总结的交易量列。这是 csv https://drive.google.com/file/d/1yTd0TB6Pp9obg4iyCWzeFIg3lin9tYVc/view?usp=sharing中的数据框
解决方案
尝试这个:
df = pd.read_csv('BTC.csv')
df['Date'] = pd.to_datetime(df['Date'])
df.set_index('Date', inplace=True)
df = df.resample('1H').agg({'Close': 'min', 'Volume': 'sum'})
print(df)
Close Volume
Date
2020-06-06 15:00:00 9650.39 201.0
2020-06-06 16:00:00 9593.09 1616.0
2020-06-06 17:00:00 9595.00 1140.0
2020-06-06 18:00:00 9606.57 642.0
2020-06-06 19:00:00 9614.44 1015.0
2020-06-06 20:00:00 9647.68 1293.0
2020-06-06 21:00:00 9678.52 1293.0
2020-06-06 22:00:00 9635.49 1021.0
2020-06-06 23:00:00 9644.18 1118.0
2020-06-07 00:00:00 9629.88 801.0
2020-06-07 01:00:00 9647.38 541.0
2020-06-07 02:00:00 9654.82 1034.0
2020-06-07 03:00:00 9671.70 710.0
2020-06-07 04:00:00 9677.98 1264.0
2020-06-07 05:00:00 9659.31 798.0
2020-06-07 06:00:00 9656.76 886.0
2020-06-07 07:00:00 9639.48 1769.0
2020-06-07 08:00:00 9599.25 3190.0
2020-06-07 09:00:00 9623.41 1332.0
2020-06-07 10:00:00 9610.64 1018.0
2020-06-07 11:00:00 9575.59 1812.0
2020-06-07 12:00:00 9499.99 5431.0
2020-06-07 13:00:00 9446.98 4372.0
2020-06-07 14:00:00 9426.07 5999.0
2020-06-07 15:00:00 9463.05 1097.0
推荐阅读
- mysql - ERROR 1227 (42000) at line 9: Access denied; you need (at least one of) the SUPER privilege(s) for this operation Operation failed with exitcode 1
- javascript - 再次运行 JavaScript 函数后需要帮助清除文本区域
- python - 如何使用一列中的值来填充另一列中的 nan,反之亦然?
- prometheus - How to display successful and failed HTTP calls to `/status` in Prometheus/Grafana?
- java - Why does PDF is not able to upload in PHP API for Android Pie, Q and R using Retrofit 2 in Android/Java? [Not solved]
- apache-spark - How to bucket tables using AWS Glue and Spark SQL?
- perl - 如何在 IMAP 邮件主题中搜索非 ascii 文本
- sql - 从 SQL Server 中的表创建表
- mysql - mySQL foreach 行运行更新
- android - 比较 Room 数据库中的日期