按字符串格式的索引列表为熊猫系列编制索引



我有一个字符串索引,看起来像:

'391:3519, 8602:12512, 17595:21505, 26588:30498, 35581:39491, 44574:48484, 53567:57477, 62560:66470, 71553:75463, 80546:84456, 89539:93449, 98532:102442, 107525:111435, 116518:120428, 125511:129421, 134504:138414, 143497:147407, 152490:156400, 161483:165393, 170476:174386, 179469:183379, 188462:192372, 197455:201365, 206448:210358, 215441:219351, 224434:228344, 233427:237337, 242420:246330, 251413:255323, 260406:264316, 269399:275264'

有人能想出一种方法用这些来索引一个系列(或DataFrame(吗?我发现异常困难

好的,找到了一种方法:

indices = '391:3519, 8602:12512, 17595:21505, 26588:30498, 35581:39491, 44574:48484, 53567:57477, 62560:66470, 71553:75463, 80546:84456, 89539:93449, 98532:102442, 107525:111435, 116518:120428, 125511:129421, 134504:138414, 143497:147407, 152490:156400, 161483:165393, 170476:174386, 179469:183379, 188462:192372, 197455:201365, 206448:210358, 215441:219351, 224434:228344, 233427:237337, 242420:246330, 251413:255323, 260406:264316, 269399:275264'
exec('df2 = df.iloc[np.r_[%s]]' % indices)
df2

(这里np.r从多个切片构建索引,exec执行字符串(

最新更新