[已解决]求助关于pandas中的索引问题

秋名86 · 发表于 2017-8-12 03:27:50

马上注册，结交更多好友，享用更多功能^_^

您需要登录才可以下载或查看，没有账号？立即注册

x

本帖最后由秋名86 于 2017-8-12 03:30 编辑

csv1长这样，2091行：
"日期","最新股价","开盘","高","低","交易量","百分比变化"
"2017年8月9日","49.33","49.06","49.64","48.91","0","0.33"
"2017年8月8日","49.17","49.31","49.79","48.86","0","-0.45"
"2017年8月7日","49.39","49.59","49.73","48.54","831.37K","-0.38"
"2017年8月4日","49.58","48.95","49.64","48.50","745.66K","1.12"
"2017年8月3日","49.03","49.59","49.96","48.78","837.76K","-1.13"
"2017年8月2日","49.59","48.80","49.65","48.55","847.72K","0.87"
"2017年8月1日","49.16","50.21","50.43","48.37","1.01M","-2.01"

csv2长这样，2088行：
"日期","最新股价","开盘","高","低","交易量","百分比变化"
"2017年8月10日","52.92","52.77","52.94","52.63","0","0.17"
"2017年8月9日","52.83","51.97","52.84","51.80","0","1.32"
"2017年8月8日","52.14","52.24","52.73","51.82","235.16K","-0.44"
"2017年8月7日","52.37","52.39","52.53","51.37","260.94K","-0.10"
"2017年8月4日","52.42","51.97","52.52","51.43","278.78K","0.79"
"2017年8月3日","52.01","52.24","52.89","51.77","402.66K","-0.67"

两表中间日期不是一一对应的。
现在需要保留两表的“最新股价”列数据，但不能按默认的整数索引对应，不然日期会乱。

我现在的做法是去除了NaN行和汉字等，把日期列处理成如下的datetime64格式的索引，最后取得了索引的交集，长度2065。
但现在没法修改索引，提示index长度不同。

"日期" 最新股价开盘高低交易量百分比变化
2017-08-09 2017-08-09 52.48 51.97 52.52 51.80 0 0.65
2017-08-08 2017-08-08 52.14 52.24 52.73 51.82 235.16K -0.44
2017-08-07 2017-08-07 52.37 52.39 52.53 51.37 260.94K -0.10

求助。

最佳答案

月排行榜 / 总排行榜

小锟

2017-8-12 12:31:36

本帖最后由小锟于 2017-8-12 12:34 编辑

把两个表都按照日期索引后，用表1.join（表2）注意改下列名

跳转到最佳答案楼层