Hi, I want to know what is the best way to keep the databases I use in different projects? I use a lot of CSVs that I need to prepare every time I’m working with them (I just copy paste the code from other projects) but would like to make some module that I can import and it have all the processes of the databases for example for this database I usually do columns = [(configuration of, my columns)], names = [names], dates = [list of columns dates], dtypes ={column: type},

then database_1 = pd.read_fwf(**kwargs), database_2 = pd.read_fwf(**kwargs), database_3 = pd.read_fwf(**kwargs)…

Then database = pd.concat([database_1…])

But I would like to have a module that I could import and have all my databases and configuration of ETL in it so I could just do something like ‘database = my_module.dabase’ to import the database, without all that process everytime.

Thanks for any help.

  • milkisklim@lemm.ee
    link
    fedilink
    arrow-up
    2
    ·
    6 months ago

    I’m not the biggest expert, but wouldn’t this be the whole point of polars’s lazy construction?

    • driving_croonerOP
      link
      fedilink
      arrow-up
      3
      ·
      6 months ago

      Never heard of that, just saw a video and even if isn’t exactly what I need it’s looked really cool.