with open('tokyo-temps.csv', 'r', encoding='shift-jis') as f: dataReader = csv.reader(f) i = 0 year = 1875 years = [] july_temps = [] for row in dataReader: if i >= 48 and (i-48)%12 == 0: years.append(year) july_temps.append(row[1]) year = year + 1 else: pass i = i + 1 with open('tokyo-july-temps.csv', 'w', encoding='shift-jis') as f: dataWriter = csv.writer(f) for year in years: dataWriter.writerow([int(year), float(july_temps[years.index(year)])])