Python_ETL

ETL processes using a Tkinter GUI with Python:

(ETL = Extraction, Transformation and Load) (GUI = graphical user-interface)

• Extract:

  • Delimited data (including or excluding headers)
  • Positional data (including or excluding headers)
  • Excel data (including or excluding headers)
  • XML data
  • JSON data
  • ... more will follow soon!

• Transform (...not yet implemented in the GUI):

  • Join data:
    • Left join
    • ... more will follow soon!
  • Group data:
    • ... more will follow soon!

• Load:

  • Delimited data
  • Positional data
  • Excel data
  • XML data
  • JSON data
  • ... more will follow soon!

GUI usage:

• Most of the GUI is self explanatory
• Header selection is separated by ";"
• Position selection is separated by ";" (and starts with "0")

Dependencies:

• Python 3 (developed in Python 3.9.7)
• openpyxl (non-standard library/module)
• xmltodict (non-standard library/module)
• dicttoxml (non-standard library/module)

TODO:

• Implement an append option
• Implement transformation options

TODO:

• Implement an append option
• Implement transformation options
• Implement search key function