擅长:python、mysql、java
<p>我想这就是你要找的。因为我不知道每个接口包含的内容的确切数量,所以我首先找到了头,然后在里面循环</p>
<pre><code>import pandas as pd
with open("sample.txt","r") as f:
lines = f.readlines()
lines = [l.strip() for l in lines]
n = len(lines)
headers = set()
for i in range(n):
if(len(lines[i])>=3):
key, value = lines[i].split(":")
headers.add(key)
hlen = len(headers)
completeList = list()
for i in range(0,n,hlen):
dictrow = dict()
for j in range(hlen):
if(j+i<n and len(lines[j+i])>=3):
key,value = lines[j+i].split(":")
dictrow[key] = value
completeList.append(dictrow)
dictrow = dict()
df = pd.DataFrame(completeList)
</code></pre>