回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个csv文件,包含一些银行的信息。共有9列。有两列,<code>id</code>和<code>parentid</code>,它们包含每个银行的id,并且也是<code>parentid</code>(<code>parentid = 0</code>,如果给定的银行是由<code>'Type = T'</code>表示的父银行)</p>
<p>我需要将所有银行分离成单独的数据帧,这样父记录的所有子记录都应该与父记录在同一个数据帧中</p>
<p>样本数据:</p>
<pre><code>type,symbol,price,quantity,expirydate,strikeprice,amendtime,id,parentid
T,ICICIBANK,1000,100,20121210,120,20121209103030,1234,0
T,AXISBANK,1000,100,20121210,120,20121209103031,1235,0
T,SBIBANK,1000,100,20121210,120,20121209103032,1236,0
P,ICICIBANK,1100,100,20121210,120,20121209103030,1237,1234
P,AXISBANK,1000,100,20121210,120,20121209103031,1238,1235
T,ICICIBANK,1000,100,20121210,120,20121209103035,1239,0
T,.CITIBANK,1000,101,20121210,120,20121209103036,1240,0
P,ICICIBANK,1100,100,20121210,120,20121209103030,1241,1234
P,ICICIBANK,1100,100,20121210,120,20121209103035,1242,1239
</code></pre>
<p>我已经使用pandas加载了csv文件,并根据Type列将子级和父级分开</p>
<p>我被剩下的部分困住了。<a href="https://i.stack.imgur.com/9px7o.png" rel="nofollow noreferrer">This is what a sample dataframe looks like</a></p>