data_filter.py

import os
import pandas as pd

lower_bound = int(input("Please enter the lower bound: "))
upper_bound = int(input("Please enter the upper bound: "))

file_list = []
for file_name in os.listdir("."):
  if file_name.endswith(".csv"):
    file_list.append(file_name)

for file_name in file_list:
  df = pd.read_csv(file_name, header=0, skiprows=1) 
  df = df[(df["X(Thompsons)"] >= lower_bound) & (df["X(Thompsons)"] <= upper_bound)]
  df = df.sort_values(by=["Y(Counts)"], ascending=False)
  print(df)
  df.to_csv("new_" + file_name, index=False)