Using some python and a scraped list I can now mark which movies we’ve seen, or have to see.
(Own the movie or have it seen streamed in the cinema)
I just have to place a X after the title in the first column.
Run the python script, and presto
First column, the list we started with.
Second column, mark the movie.
3rd until the end .. years 2000-2023
Blue – seen
Light Blue – seen but was not in original list (so a new movie)
Green – have this movie, but still have to watch it
Light Green – Have this movie but it’s not in the original list
Orange – New in that year (could be an oldie reemerging in the top 250)
Now the python script, maybe it useful for you.
# 20230813 18:49 IMDB overview
# pip install openpyxl
import openpyxl
from openpyxl.styles import PatternFill
from openpyxl.styles.colors import Color
wb = openpyxl.load_workbook("clearsheet.xlsx")
sheet = wb['Sheet1']
colors = ['00660066', '00FFFFCC',
'007b8cf2', '005ace97', '00ffac58','00dddddd','009bd8ff','007aeeb7']
fillers = []
for color in colors:
temp = PatternFill(patternType='solid',
fgColor=color)
fillers.append(temp)
# Mark found previous years
for colt in range(4, 27):
for colr in range(3, colt):
for rowr in range(2, 252):
for rowrr in range(2, 252):
if sheet.cell(row=rowrr, column=colr).value == sheet.cell(row=rowr, column=colt).value :
sheet.cell(row=rowr, column=colt).fill = fillers[4]
# Mark Our Old list matched with all years
for titlerow in range(2, 252):
for colr in range(3, 26):
for rowr in range(2, 252):
if sheet.cell(row=titlerow, column=1).value == sheet.cell(row=rowr, column=colr).value :
sheet.cell(row=titlerow, column=1).fill = fillers[5]
# Mark Have / Seen
for title in range(2, 252):
for j in range(3, 27):
for i in range(2, 252):
if sheet.cell(row=i, column=j).value == sheet.cell(row=title, column=1).value :
if sheet.cell(row=title, column=2).value == "x":
sheet.cell(row=i, column=j).fill = fillers[2]
else:
sheet.cell(row=i, column=j).fill = fillers[3]
# Mark non old list but seen
for title in range(252, 400):
for j in range(3, 27):
for i in range(2, 252):
if sheet.cell(row=i, column=j).value == sheet.cell(row=title, column=1).value :
if sheet.cell(row=title, column=2).value == "x":
sheet.cell(row=i, column=j).fill = fillers[6]
else:
sheet.cell(row=i, column=j).fill = fillers[7]
# Info cells
sheet['D255'] = "Downloaded seen org list"
sheet['D256'] = "Downloaded not seen org list"
sheet['D257'] = "Title matches found in 2000-2023"
sheet['D258'] = "Titles found in 2000-2023 not in org list have"
sheet['D259'] = "Titles found in 2000-2023 not in org list have seen"
sheet['D260'] = "Titles found in 2000-2023 previous years"
sheet.cell(row=255, column=4).fill = fillers[2]
sheet.cell(row=256, column=4).fill = fillers[3]
sheet.cell(row=257, column=4).fill = fillers[5]
sheet.cell(row=258, column=4).fill = fillers[7]
sheet.cell(row=259, column=4).fill = fillers[6]
sheet.cell(row=260, column=4).fill = fillers[4]
wb.save("imdbexport.xlsx")
