擅长:python、mysql、java
<p>在创建DF之前准备好数据</p>
<pre><code>def get_number(lst):
for x in lst:
if x[1] == 'Number':
return x[0]
return None
data = [['location1', [(123, 'Number'),('Main', 'Street'),('New York', 'City')]], ['location2', [('Broadway', 'Street'),('New York', 'City'),(11111, 'ZIP')]], ['location3', [(987, 'Number'),('Grand', 'Street'),('Chicago', 'City'), (55555,'ZIP')]]]
for entry in data:
entry.append(get_number(entry[1]))
print(data)
# now you can create the DF
</code></pre>
<p>输出</p>
<pre><code>[['location1', [(123, 'Number'), ('Main', 'Street'), ('New York', 'City')], 123], ['location2', [('Broadway', 'Street'), ('New York', 'City'), (11111, 'ZIP')], None], ['location3', [(987, 'Number'), ('Grand', 'Street'), ('Chicago', 'City'), (55555, 'ZIP')], 987]]
</code></pre>