To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Exce
1 answer:
You might be interested in
Answer:
python code below:
names={}#first dictionary for names and favorite
favor={}#radish type and how many are favorite
f=open("raddish.txt")#opening file
for i in f:#for each line
j=i.strip().split("-")#splitting base on -
names[j[0].strip()]=j[1].strip()#getting first dictionary
if j[1].lower().strip() in favor:#counting the favorite elements
favor[j[1].lower().strip()]+=1
else:
favor[j[1].lower().strip()]=1
print ("First Dictionary",names)#printing the names
print("second dictionary:",favor)#printing the favorite numbers
f.close()#closing file
Explanation:
The program was implemented using python programming language.
Its operation is to read the file, (strip the carriage returns), create a dictionary of names and favorite radishes and create a dictionary of each radish type and the number of people who chose that as their favorite.
It returns as output the names of people entered for the Radishes.
See attachment for screenshot.
