import pandas as pd

df = pd.read_csv("../DES5YR.FITRES.gz", comment="#", sep=r'\s+')


CIDS = pd.read_csv("Region_1", header=None, names=["text"])
dft = df.loc[df.CID.isin(CIDS.text)]
dft.to_csv("REGION_1.DAT", sep=" ", index=False)

CIDS = pd.read_csv("Region_2", header=None, names=["text"])
dft = df.loc[df.CID.isin(CIDS.text)]
dft.to_csv("REGION_2.DAT", sep=" ", index=False)

CIDS = pd.read_csv("Region_3", header=None, names=["text"])
dft = df.loc[df.CID.isin(CIDS.text)]
dft.to_csv("REGION_3.DAT", sep=" ", index=False)