回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我不知道这是否可能,但我正在尝试通过索引从拆分字符串中访问单词(而不是单个字符),并将其存储在字典中。如果这不能工作,请有任何其他的建议,如何着手获得相同的结果。这是我目前的代码:</p>
<pre><code>def main():
if len(argv) != 2:
print("usage: python import.py (csv file)")
exit(0)
db = SQL("sqlite:///students.db")
file = open(argv[2], 'r')
csv_file = DictReader(file)
for row in csv_file:
names = row['name']
for i in names:
word = i.split()
# what the csv looks like
name,house,birth
Adelaide Murton,Slytherin,1982
Adrian Pucey,Slytherin,1977
Anthony Goldstein,Ravenclaw,1980
# what i want it to look like
first name,middle name,last name,house,birth
Adelaide,None,Murton,Slytherin,1982
Adrian,None,Pucey,Slytherin,1977
Anthony,None,Goldstein,Ravenclaw,1980
</code></pre>