concatstops.py

import xlrd
import os

path = "C:\\users\\nx7233pl\\Documents\\school\\STAT210\\"
output = path + "bike-stops.txt"
book = xlrd.open_workbook(path + "citibike-concat-stops.xlsx")
print(book.sheet_names()) # []
sheet = book.sheet_by_index(0) # Index out of bounds

firstCell = (1,16)
lastCell = (1048575,16)

stops = []

for x in range(firstCell[0], lastCell[0] + 1):
    stop = int(sheet.cell(x,16))
    if stop not in stops:
        stops[stop] = 1
    else:
        stops[stop] += 1
        
with open(output, 'w') as file:
    for stop in stops:
        file.write('Stop %s %s'%(str(stop) + ':', stops[stop]))