分箱后，如何得到分组的字符串格式数组

最新推荐文章于 2024-10-04 22:36:54 发布

Happy_doggy

最新推荐文章于 2024-10-04 22:36:54 发布

阅读量359

点赞数 8

文章标签：人工智能

本文链接：https://blog.csdn.net/Happy_doggy/article/details/134650906

版权

import pandas as pd

departure = pd.cut(sorted(train['Departure Delay in Minutes']), [x for x in range(0,1630,30)]).value_counts()
#departure是pandas.core.series.Series格式，索引+值

#这里的问题是索引（departure.index）是pandas.core.indexes.category.CategoricalIndex（也不知道是啥）切片获得的就是interval不是字符串

IN[]:CategoricalIndex([     (0, 30],     (30, 60],     (60, 90],    (90, 120],
                    (120, 150],   (150, 180],   (180, 210],   (210, 240],
                    (240, 270],   (270, 300],   (300, 330],   (330, 360],
                    (360, 390],   (390, 420],   (420, 450],   (450, 480],
                    (480, 510],   (510, 540],   (540, 570],   (570, 600],
                    (600, 630],   (630, 660],   (660, 690],   (690, 720],
                    (720, 750],   (750, 780],   (780, 810],   (810, 840],
                    (840, 870],   (870, 900],   (900, 930],   (930, 960],
                    (960, 990],  (990, 1020], (1020, 1050], (1050, 1080],
                  (1080, 1110], (1110, 1140], (1140, 1170], (1170, 1200],
                  (1200, 1230], (1230, 1260], (1260, 1290], (1290, 1320],
                  (1320, 1350], (1350, 1380], (1380, 1410], (1410, 1440],
                  (1440, 1470], (1470, 1500], (1500, 1530], (1530, 1560],
                  (1560, 1590], (1590, 1620]],
                 categories=[(0, 30], (30, 60], (60, 90], (90, 120], ..., (1500, 1530], (1530, 1560], (1560, 1590], (1590, 1620]], ordered=True, dtype='category')

interval = departure.index.astype(str)

IN[]:Index(['(0, 30]', '(30, 60]', '(60, 90]', '(90, 120]', '(120, 150]',
       '(150, 180]', '(180, 210]', '(210, 240]', '(240, 270]', '(270, 300]',
       '(300, 330]', '(330, 360]', '(360, 390]', '(390, 420]', '(420, 450]',
       '(450, 480]', '(480, 510]', '(510, 540]', '(540, 570]', '(570, 600]',
       '(600, 630]', '(630, 660]', '(660, 690]', '(690, 720]', '(720, 750]',
       '(750, 780]', '(780, 810]', '(810, 840]', '(840, 870]', '(870, 900]',
       '(900, 930]', '(930, 960]', '(960, 990]', '(990, 1020]', '(1020, 1050]',
       '(1050, 1080]', '(1080, 1110]', '(1110, 1140]', '(1140, 1170]',
       '(1170, 1200]', '(1200, 1230]', '(1230, 1260]', '(1260, 1290]',
       '(1290, 1320]', '(1320, 1350]', '(1350, 1380]', '(1380, 1410]',
       '(1410, 1440]', '(1440, 1470]', '(1470, 1500]', '(1500, 1530]',
       '(1530, 1560]', '(1560, 1590]', '(1590, 1620]'],
      dtype='object')

labels=[]

for i in range(0,16):
labels.append(interval[i])