Advertisement
Guest User

Untitled

a guest
Aug 21st, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. class DAO:
  2. def get_df(self,file_path,delim):
  3. df=pd.read_csv(filepath_or_buffer=file_path,delimiter=delim)
  4. return df
  5. class Preference(DAO):
  6. def cleanse_df(self,df):
  7. df_dropped_nan=df.dropna(axis=0,how='any')[df.item_id!='1']
  8. df1=df_dropped_nan[df_dropped_nan.user_id.apply(lambda x: x.isnumeric())]
  9. df2 = df1[df1.item_id.apply(lambda x: x.isnumeric())]
  10. df2.item_id = df2.item_id.astype(int)
  11. df2.user_id=df2.user_id.astype(int).copy()
  12. return df2
  13. def get_cleansed_df(self,file_path,delim):
  14. df=DAO.get_df(self,file_path,delim)
  15. cleansed_df=self.cleanse_df(df)
  16. return cleansed_df
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement