擅长:python、mysql、java
<p>不确定最后是否需要一个或两个函数。这里我把它们作为两个独立的函数。你知道吗</p>
<pre><code>import pandas as pd
#read in the file
csvfile = pd.read_csv(r'C:\Users\wrich\Desktop\data.csv')
#import the other dictionary
names_dictionary = {1: 'Bob West', 2: 'Hannah North', 3: 'Bruce South', 4: 'Anna Bell', 5: 'George Smith'}
def names(names_dictionary, csvfile):
#manipulate the file to get the values you want
csvfile = pd.DataFrame(csvfile[' A '].str.split(' ',1).tolist(), columns = ['id','value'])
myValues = list(csvfile['value'])
#output the result
result = {}
for entry in range(len(myValues)):
result[names_dictionary[entry + 1]] = myValues[entry]
return result
result = names(names_dictionary, csvfile)
def mainFunction(result):
myString = ''
for val in result.keys():
myString += val + ' got ' + str(result[val]) + ' bananas '
return myString
answer = mainFunction(result)
</code></pre>