Snow
Snow
Programming language:Whatever
2021-07-23 08:26:45
0
Q:

how to fix the rank in jupyter notebook

William Kinaan
William Kinaan
Code: Whatever
2021-08-26 10:54:26 
#Convert the list into CSV file
mycsv = csv.writer(open(r'C:\Users\ashen\OneDrive\Desktop\ITSS 4355.001 - Data Visualization - F20\Ashenafe.csv','w', newline=''))
for row in list1:
#Fetching the row index
#No calculation is done at header level
    e= list1.index(row)
#Compare the year value of the current record with the year value of the previous record
#if same calculate the rank, if different assign the rank as one
    if row[1] != c and e != 0:
        v=1
        C= row[1]
        row[3]= v
    else:
        if row[1] == c and e != 0:
            v+=1
            row[3]= v
#write row to csv
    mycsv.writerow(row)
0

Tags

Related

New to Communities?

Join the community