make target list.py

import tqdm
import pandas as pd

targets = []
quarters = range(0, 18, 1)
for q in tqdm.tqdm(quarters):
    quarter = str(q).zfill(2)
    df = pd.read_csv(
        f"https://archive.stsci.edu/missions/kepler/download_scripts/lightcurves/kepler_lightcurves_Q{quarter}_long.sh",
        skiprows=1,
        header=None,
    )
    KICIDS = df[0].str.split("/", expand=True)[3]

    targets.append(pd.DataFrame({"KICID": KICIDS, "QUARTER": [q] * len(KICIDS)}))

all_targets = pd.concat(targets)
all_targets.value_counts("KICID").reset_index().to_csv(
    "quarters_condensed.csv", index=False
)