擅长:python、mysql、java
<p>我希望我没弄错</p>
<pre><code># Read the CSV & assign it to `text`
with open('estcreate.csv', 'r') as fh:
text = fh.read()
enc = dict()
for line in text.splitlines()[1:]:
status, enclosure, bay, bay_no, vds, *na = line.split()
enclosure = enclosure.replace(',','').upper()
vds = vds.lower().split('.')[0]
if enclosure not in enc:
enc[enclosure] = dict()
if bay_no not in enc[enclosure]:
enc[enclosure][bay_no] = vds
>>> df = pd.DataFrame.from_dict(enc)
>>> df
ENC2010 ENC1011 ENC1012 ENC2004 ENC2006 ENC2011 ENC1003 ENC1006 ENC1007 ENT0003 ... ENC1010 ENC1005 ENC7009 ENC2007 ENC7005 ENC7006 ENC2014 ENC2005 ENC1018 ENC1025
1 tdm2066 tdm1068 tdm1083 tdm2033 vds2009 tdm2081 tdm1024 vds1009 vds1023 vds0003 ... vds1041 vds1001 vds7025 vds2023 tdm7068 vds7006 tdm2126 vds2001 tdm1173 tdm1250
>>> df.T
1
ENC2010 tdm2066
ENC1011 tdm1068
ENC1012 tdm1083
ENC2004 tdm2033
ENC2006 vds2009
ENC2011 tdm2081
...
</code></pre>