Mar-06-2020, 04:06 PM
Hey guys,
I wanted to develop my coding so i am about to learn OOP.
I want to build class which will:
1) read excel file in the folder
2)transfer it into dataframe
I was able to do:
I wanted to develop my coding so i am about to learn OOP.
I want to build class which will:
1) read excel file in the folder
2)transfer it into dataframe
I was able to do:
class df_excel: def __init__(self, filename, sheetname): self.file = filename self.sheetname = sheetname def excel_to_df(self): self.create_df = pd.read_excel(self.file, self.sheetname) return self.create_df A = df_excel(r'C:\Users\user\test.xlsx', 'Database_sheet') df = A.excel_to_df() print(df)But i would like to skip providing filename, and make it automatized with function:
def get_names(self): cwd = os.getcwd() for file in os.listdir(cwd): if file.endswith('.xlsx'): filename = cwd + '\\' + file return filenamei am confused how to combine it into 1 class... Please help :(