使用python将过滤后的数据帧存储在新的数据帧中

Question

我有一个大约142264行的数据帧：

样品：

              DateAndTime  TAGID  TagValue  UIB
  2017-04-26 00:00:00.000    100       0.9  NaN
  2017-04-26 00:00:00.000    101     430.3  NaN
  2017-04-26 00:00:00.000    102     112.7  NaN
  2017-04-26 00:00:00.000    103      50.0  NaN
  2017-04-26 00:00:00.000    104     249.4  NaN
  2017-04-26 00:00:00.000    105     109.9  NaN
  2017-04-26 00:00:00.000    106     248.4  NaN
  2017-04-26 00:00:00.000    107     131.5  NaN
  2017-04-26 00:00:00.000    108     247.7  NaN
  2017-04-26 00:00:00.000    109      96.8  NaN
  2017-04-26 00:00:00.000    113     481.4  NaN
  2017-04-26 00:00:00.000    114     243.9  NaN
  2017-04-26 00:00:00.000    115    -416.0  NaN
  2017-04-26 00:00:00.000    116      -0.5  NaN
  2017-04-26 00:00:00.000    117     429.2  NaN
  2017-04-26 00:00:00.000    118     646.4  NaN
  2017-04-26 00:00:00.000    119      49.5  NaN
  2017-04-26 00:00:00.000    120     248.2  NaN
  2017-04-26 00:01:00.000    100       0.9  NaN
  2017-04-26 00:01:00.000    101     429.7  NaN
  2017-04-26 00:01:00.000    102     120.0  NaN
  2017-04-26 00:01:00.000    103      49.9  NaN
  2017-04-26 00:01:00.000    104     249.2  NaN
  2017-04-26 00:01:00.000    105     123.8  NaN
  2017-04-26 00:01:00.000    106     248.3  NaN
  2017-04-26 00:01:00.000    107     136.3  NaN
  2017-04-26 00:01:00.000    108     247.4  NaN
  2017-04-26 00:01:00.000    109      99.9  NaN
  2017-04-26 00:01:00.000    113     481.4  NaN
  2017-04-26 00:01:00.000    114     243.9  NaN

我想过滤唯一tagid上的dataframe并单独存储新的dataframe

我试过：

data = read_json("json_tagid_100_120.json")
tagid101 = data[data["TAGID"] == 101]
print tagid101

这样，我只能存储Tagid 101的数据

但是我想把单个tagid的数据存储在一个新的数据框中

Answer 1

我认为最好的方法是通过将DataFrameGroupBy对象转换成tuple然后再转换成dict来创建所有DataFrames：

dfs = dict(tuple(data.groupby("TAGID")))

print (dfs[101])
           DateAndTime  TAGID  TagValue  UIB
1  2017-04-26 00:00:00    101     430.3  NaN
19 2017-04-26 00:01:00    101     429.7  NaN