old_contents: from zipfile import ZipFile
  import pandas as pd
  import os
  
  ZIP_FILE = "anime-recommendations-database"
  DATA_FILE = "anime.csv"
  NEW_DATA_FILE = "anime_cleaned.csv"
  
  def clean_by_id(df):
      ids = df.iloc[:,0]
      drops=[]
      
      for i in range(len(ids)):
          if not str(ids[i]).isdigit():
              drops.append(i)
              
      df = df.drop( df.index[ drops ] )
      return df
  
  def clean_by_rating(df):
      rates = df.iloc[:,-1]
      drops=[]
      
      for i in range(len(rates)):
          if not isinstance( rates[i], float ):
              drops.append(i)
          elif rates[i] < 0 or str(rates[i])=="nan":
              drops.append(i)
      df = df.drop( df.index[ drops ] )
      return df
  
  def clean_genres(df):
      genres = df.iloc[:,2]
      
      drops=[]
      for i in range(len(genres)):
          if str(genres[i]) == "nan" or str(genres[i]) == "NaN":
              drops.append(i)
              
      df = df.drop( df.index[ drops ] )
      return df
      
      
  def open_zip(zipfile, datafile):
      with ZipFile('{0}.zip'.format(zipfile), 'r') as myzip:
          myzip.extract(datafile)
          
  def clean_traces(datafiles):
      for datafile in datafiles:
          os.remove(datafile, dir_fd=None)
          
          
  def create_dataframe(datafile):
      df = pd.read_csv(datafile, encoding = 'utf8')
      remove = [3,4,6]
      df.drop( df.columns[remove], axis=1, inplace=True )
      
      df = clean_by_id(df)
      df = df.reset_index(drop=True)
      df = clean_by_rating(df)
      df = df.reset_index(drop=True)
      df = clean_genres(df)
      df = df.reset_index(drop=True)
      
      return df
  
  def generate_database(df, datafile):
      df.to_csv(datafile, encoding='utf-8', index=False)
      print("Database created in " + datafile)
    
  
  open_zip(ZIP_FILE, DATA_FILE)
  dataframe = create_dataframe(DATA_FILE)
  generate_database(dataframe, NEW_DATA_FILE)
  clean_traces( [DATA_FILE] )
      
      
      
      
      
      
new_contents: from zipfile import ZipFile
  import pandas as pd
  import os
  
  ZIP_FILE = "anime-recommendations-database"
  DATA_FILE = "anime.csv"
  NEW_DATA_FILE = "anime_cleaned.csv"
  DIR = "DATABASE"
  
  def clean_by_id(df):
      ids = df.iloc[:,0]
      drops=[]
      
      for i in range(len(ids)):
          if not str(ids[i]).isdigit():
              drops.append(i)
              
      df = df.drop( df.index[ drops ] )
      return df
  
  def clean_by_rating(df):
      rates = df.iloc[:,-1]
      drops=[]
      
      for i in range(len(rates)):
          if not isinstance( rates[i], float ):
              drops.append(i)
          elif rates[i] < 0 or str(rates[i])=="nan":
              drops.append(i)
      df = df.drop( df.index[ drops ] )
      return df
  
  def clean_genres(df):
      genres = df.iloc[:,2]
      
      drops=[]
      for i in range(len(genres)):
          if str(genres[i]) == "nan" or str(genres[i]) == "NaN":
              drops.append(i)
              
      df = df.drop( df.index[ drops ] )
      return df
      
      
  def open_zip(zipfile, datafile):
      with ZipFile('{0}.zip'.format(zipfile), 'r') as myzip:
          myzip.extract(datafile)
          
  def clean_traces(datafiles):
      for datafile in datafiles:
          os.remove(datafile, dir_fd=None)
          
          
  def create_dataframe(datafile):
      df = pd.read_csv(datafile, encoding = 'utf8')
      remove = [3,4,6]
      df.drop( df.columns[remove], axis=1, inplace=True )
      
      df = clean_by_id(df)
      df = df.reset_index(drop=True)
      df = clean_by_rating(df)
      df = df.reset_index(drop=True)
      df = clean_genres(df)
      df = df.reset_index(drop=True)
      
      return df
  
  def generate_database(df, datafile, dirc):
      if not os.path.exists(dirc):
          os.makedirs(dirc)
      datafile = dirc + "\\" + datafile
      df.to_csv(datafile, encoding='utf-8', index=False)
      print("Database created in " + datafile)
    
  
  open_zip(ZIP_FILE, DATA_FILE)
  dataframe = create_dataframe(DATA_FILE)
  generate_database(dataframe, NEW_DATA_FILE, DIR)
  clean_traces( [DATA_FILE])
      
  
subject: Store the generated files in DATABASE