Skip to content

Provides some Complex-data specific tools (raw -> consistent -> Postgresql)

Notifications You must be signed in to change notification settings

ritazagoni/complex-to-psql-tools

 
 

Repository files navigation

complex-to-psql-tools

Provides some Complex-data specific tools (raw -> consistent -> Postgresql):

  • drop-invalid-dates comma,separated,date,fields input.csv output.csv converts date fields to Python dates, fields failing to convert are replaced with None/null
  • generate-date-fixer R_export.txt.xls generate a script suitable for parallel --gnu that will create fixed rovat csvs when run
  • create-table-fields R_export.txt.xls creates rovat_n.fields files to be used by csv_to_psql
  • rovat-to-psql rovat_n.csv rovat_n.fields helps loading rovat_n.csv properly into Postgres (uses csv_to_psql) creates table with correct field types and primary key on (ceg_id, alrovat_id)

About

Provides some Complex-data specific tools (raw -> consistent -> Postgresql)

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 98.3%
  • Makefile 1.7%