import pandas as pd import glob

path = r"C:\12*.xls" for fname in glob.glob(path): df = pd.read_excel(fname, skiprows=2) df["Percent Physical Memory"] = df["Percent Physical Memory"].str.replace("%", "") df["Percent Physical Memory"] = ( df["Percent Physical Memory"].str.replace(r"%", r".0").astype("float") / 100.0 ) df["Percent Physical Memory"] = 100 * df["Percent Physical Memory"] df = df[ (df["Node Name"] == "RackHP2") | (df["Node Name"] == "RackHP3") | (df["Node Name"] == "RackHP4") | (df["Node Name"] == "RackHP5") | (df["Node Name"] == "SCDPM21") | (df["Node Name"] == "SCDPM10") | (df["Node Name"] == "IBM-Blad1") | (df["Node Name"] == "IBM-Blad2") | (df["Node Name"] == "BladeHP3") | (df["Node Name"] == "BladeHP7") | (df["Node Name"] == "BladeHP10") | (df["Node Name"] == "RackDell1") | (df["Node Name"] == "RackDell3") | (df["Node Name"] == "RackDell4") ] xl = df.groupby("Node Name")["Percent Physical Memory"].sum().reset_index() xl.to_csv(fnhttps://www.reddit.com/help/contentpolicy?utm_source=reddit&utm_medium=usertext&utm_name=learnpython&utm_content=t1_fgozy9lame)