/extract_excel_csv_data_recursively

A very basic GUI app for extracting data from multiple source files into a single csv file

Primary LanguagePython

extract_excel_csv_data_recursively

A very basic GUI app for extracting data from multiple source files into a single csv file

Function

Explanation of the underlying function

Usage

The script can directly be copied to a Jupyter cell or can be run from terminal. Following command should ensure all dependencies are installed:

py -m pip install pandas, numpy, pysimplegui

Some things the GUI takes care of are:

  • Allows selection of columns to be extracted from a sample .csv file
  • Allows user to specify which of the selected columns should be parsed as date
  • Gives a date based filename to output
  • Shows colour coded log for which files were read in green and which were ignored in red background.

Screenshots

Empty Form

image

Filled Form

image

Displays extracted output

image

Displays filename of the output and location where it is saved

image

Colour coded log

image