<p>这是一个过于具体的功能,我为阅读你的邮件的鱼部分,一旦我把它放在一个文本文件。它假设你已经提取了日期和扇区。在</p>
<p>它可能不完全适用于您的实现,但希望python字符串方法的使用将使您走上正确的方向,并向您展示如何将它们全部添加到数据帧中。在</p>
<pre><code>def fish_to_frame(fish_file, sector, date):
# Initialize some lists
species = []
pounds = []
prices = []
date = pd.to_datetime(date, infer_datetime_format=True)
with open(fish_file) as f:
for line in f:
# Fish: weight @ price
fish, remainder = line.split(':')
if '@' in remainder:
weight, price = remainder.split('@')
if 'trade' in remainder:
weight, price = remainder.split('to ')
weight = weight.strip(' lbs')
species.append(fish)
pounds.append(weight)
prices.append(price)
fish_frame = pd.DataFrame({'Species':species,
'Sector':sector,
'Pounds':pounds,
'Prices':prices,
'Date':date})
return fish_frame
</code></pre>
<p>你可以在那里做一些额外的步骤,把权重等转换成数字等等。希望这有帮助!在</p>
<p>另外一个步骤可以是将它与已有的数据帧和那些已经存在的列结合起来。但是逐行添加新条目会很慢(er)。在</p>