擅长:python、mysql、java
<p>这应该很管用。你知道吗</p>
<pre><code>import pandas as pd
from io import StringIO
df=[]
with open("a.txt","r") as file:#load file with context
stream_string=""
for line in file:#loop on each line
if line.startswith("LC "):#detect LC
#store LC for retrival
lc=str(line).replace("LC ","").replace("\n","").strip()
elif line!="\n":
#append line to string if not \n
stream_string+=line
else:
#read string into pandas and add to list
data=pd.read_csv(StringIO(stream_string),sep=" ")
data["LC"]=lc
df.append(data)
stream_string=""
else:
#codes for EOF
data=pd.read_csv(StringIO(stream_string),sep=" ")
data["LC"]=lc
df.append(data)
#create df by joining df in list
df=pd.concat(df,ignore_index=True)
</code></pre>