A very basic GUI app for extracting data from multiple source files into a single csv file
Explanation of the underlying function
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.