Data Preprocessing Helper (Release v0.3.8)

Introduction

This is a release of the software Data Preprocessing Helper to help people cleaning time-of-change data by converting them into appropriate spreadsheet files with constant time intervals. It also does interpolation to replace invalid values and converts the time column to numerical values upon request. The development is currently conducted on 64-bit (amd64) and 32-bit (win32) Windows machines only so only binaries of Windows machines are available. We have also tested the software with Wine. v0.3.8 (This version) has been tested with wine-3.0.1 stable in Linux Mint 18.3 and works in it. If you're not sure which version of zip file you should download, please check this Microsoft FAQ website or download the 32-bit (win32) version.

There are six files in the zip file

• Changelog: change log from the previous version (v0.3.7)
• DataPreprocessingHelper.exe: the executable with the graphical user interface
• ExampleTimeofChangeData.csv: example dirty file
• License.txt: GPL v3 license file
• MissingData.xls: example file for testing the interpolation function
• UserManual.pdf: user manual with a tutorial to begin the use of the software

For other operating systems that cannot use Wine, please follow the instructions in the directory exe to compile the executable yourself.

If you have questions, bug reports or suggestions on improvement, please put them into the issue tracker or contact Howard Cheung directly by email at howard.at (at) gmail.com.

Change log from v0.3.7 to v0.3.8

• Fix a critical bug by skipping rows with duplicated time entries

Data Preprocessing Helper (Release v0.3.7)

Introduction

This is a release of the software Data Preprocessing Helper to help people cleaning time-of-change data by converting them into appropriate spreadsheet files with constant time intervals. It also does interpolation to replace invalid values and converts the time column to numerical values upon request. The development is currently conducted on 64-bit (amd64) and 32-bit (win32) Windows machines only so only binaries of Windows machines are available. We have also tested the software with Wine. v0.3.7 (This version) has been tested with wine-2.0.3 stable in Linux Mint 18.3 and works in it. If you're not sure which version of zip file you should download, please check this Microsoft FAQ website or download the 32-bit (win32) version.

There are six files in the zip file

• Changelog: change log from the previous version (v0.3.6)
• DataPreprocessingHelper.exe: the executable with the graphical user interface
• ExampleTimeofChangeData.csv: example dirty file
• License.txt: GPL v3 license file
• MissingData.xls: example file for testing the interpolation function
• UserManual.pdf: user manual with a tutorial to begin the use of the software

For other operating systems, please follow the instructions in the directory exe to compile the executable yourself.

If you have questions, bug reports or suggestions on improvement, please put them into the issue tracker or contact Howard Cheung directly by email at howard.at (at) gmail.com.

Change log from v0.3.6

• Fix a critical bug for the step function assumption when the time interval in the new file is larger than that of the original file

Data Preprocessing Helper (Release v0.3.6)

Introduction

This is a release of the software Data Preprocessing Helper to help people cleaning time-of-change data by converting them into appropriate spreadsheet files with constant time intervals. It also does interpolation to replace invalid values and converts the time column to numerical values upon request. The development is currently conducted on 64-bit (amd64) and 32-bit (win32) Windows machines only so only binaries of Windows machines are available. If you're not sure which version of zip file you should download, please check this Microsoft FAQ website or download the 32-bit (win32) version.

There are six files in the zip file

• Changelog: change log from the previous version (v0.3.4)
• DataPreprocessingHelper.exe: the executable with the graphical user interface
• ExampleTimeofChangeData.csv: example dirty file
• License.txt: GPL v3 license file
• MissingData.xls: example file for testing the interpolation function
• UserManual.pdf: user manual with a tutorial to begin the use of the software

For other operating systems, please follow the instructions in the directory exe to compile the executable yourself.

If you have questions, bug reports or suggestions on improvement, please put them into the issue tracker or contact Howard Cheung directly by email at howard.at (at) gmail.com.

Change log from v0.3.5

• Separate settings to basic and advanced for gentler learning curve
• Better error handling for file permission errors

Data Preprocessing Helper (Release v0.3.5)

Introduction

This is a release of the software Data Preprocessing Helper to help people cleaning time-of-change data by converting them into appropriate spreadsheet files with constant time intervals. It also does interpolation to replace invalid values and converts the time column to numerical values upon request. The development is currently conducted on 64-bit (amd64) and 32-bit (win32) Windows machines only so only binaries of Windows machines are available. If you're not sure which version of zip file you should download, please check this Microsoft FAQ website or download the 32-bit (win32) version.

There are six files in the zip file

• Changelog: change log from the previous version (v0.3.4)
• DataPreprocessingHelper.exe: the executable with the graphical user interface
• ExampleTimeofChangeData.csv: example dirty file
• License.txt: GPL v3 license file
• MissingData.xls: example file for testing the interpolation function
• UserManual.pdf: user manual with a tutorial to begin the use of the software

For other operating systems, please follow the instructions in the directory exe to compile the executable yourself.

If you have questions, bug reports or suggestions on improvement, please put them into the issue tracker or contact Howard Cheung directly by email at howard.at (at) gmail.com.

Change log from v0.3.4

• Add function to auto-detect the input time string. The user may not need to enter the input time string according to the instructions at the Python website.
• Add 32-bit windows application of the data preprocessing helper

Data Preprocessing Helper (Release v0.3.4)

Introduction

This is a release of the software Data Preprocessing Helper to help people cleaning time-of-change data by converting them into appropriate spreadsheet files with constant time intervals. It also does interpolation to replace invalid values and converts the time column to numerical values upon request. The development is currently conducted on 64-bit Windows machines only so only binaries of 64-bit Windows machines are available. There are six files in the zip file

• Changelog: change log from the previous version (v0.3.3)
• DataPreprocessorHelper.exe: the executable with the graphical user interface
• ExampleTimeofChangeData.csv: example dirty file
• License.txt: GPL v3 license file
• MissingData.xls: example file for testing the interpolation function
• UserManual.pdf: user manual with a tutorial to begin the use of the software

For other operating systems, please follow the instructions in the directory exe to compile the executable yourself.

If you have questions, bug reports or suggestions on improvement, please put them into the issue tracker or contact Howard Cheung directly by email at howard.at (at) gmail.com.

Change log from v0.3.3

• Debug for incorrect import of numeric data as string data, resulting in NaN values in multiple columns

Data Preprocessing Helper (Release v0.3.3)

Introduction

This is a release of the software Data Preprocessing Helper to help people cleaning time-of-change data by converting them into appropriate spreadsheet files with constant time intervals. It also does interpolation to replace invalid values and converts the time column to numerical values upon request. The development is currently conducted on 64-bit Windows machines only so only binaries of 64-bit Windows machines are available. There are six files in the zip file

• Changelog: change log from the previous version (v0.3.2)
• DataPreprocessorHelper.exe: the executable with the graphical user interface
• ExampleTimeofChangeData.csv: example dirty file
• License.txt: GPL v3 license file
• MissingData.xls: example file for testing the interpolation function
• UserManual.pdf: user manual with a tutorial to begin the use of the software

For other operating systems, please follow the instructions in the directory exe to compile the executable yourself.

If you have questions, bug reports or suggestions on improvement, please put them into the issue tracker or contact Howard Cheung directly by email at howard.at (at) gmail.com.

Changelog from v0.3.2

=======================================================

• Debug to filter data based on the given time span only and ignore the rest of the data in the dataframe
• Debug to give correct beginning values when step function assumption and intermediate starting time is used
• Debug for the computer generated ending time: the last index in the new dataframe should come after the last index of the original dataframe, and the second last index in the new dataframe should come before the last index of the original one
• Add new feature to put blanks for data points that happen before the preprocessed data

Data Preprocessing Helper (v0.3.2)

Introduction

This is a release of the software Data Preprocessing Helper to help people cleaning time-of-change data by converting them into appropriate spreadsheet files with constant time intervals. It also does interpolation to replace invalid values and converts the time column to numerical values upon request. The development is currently conducted on 64-bit Windows machines only so only binaries of 64-bit Windows machines are available. There are six files in the zip file

• Changelog: change log from the previous version (v0.3.1-alpha)
• DataPreprocessorHelper.exe: the executable with the graphical user interface
• ExampleTimeofChangeData.csv: example dirty file
• License.txt: GPL v3 license file
• MissingData.xls: example file for testing the interpolation function
• UserManual.pdf: user manual with a tutorial to begin the use of the software

For other operating systems, please follow the instructions in the directory exe to compile the executable yourself. I'm sorry for the inconvenience.

If you have questions, bug reports or suggestions on improvement, please put them into the issue tracker or contact Howard Cheung directly by email at howard.at (at) gmail.com.

Changelog from v0.3.1-alpha

• Typo and formatting issues on GUI
• Fix an issue with string characters in the algorithm that finds the first valid values
• Improve speed and error handling
• Improve documentation by explaining all input files and adding one more tutorial

Data Preprocessing Helper (Pre-release v0.3.1-alpha)

Introduction

This is a pre-release of the software Data Preprocessing Helper to help people cleaning time-of-change data by converting them into appropriate spreadsheet files with constant time intervals. The development is currently conducted on 64-bit Windows machines only so only binaries of 64-bit Windows machines are available. There are six files in the zip file

• Changelog: change log from the previous version (v0.2.2-alpha)
• DataPreprocessorHelper.exe: the executable with the graphical user interface
• ExampleTimeofChangeData.csv: example dirty file
• License.txt: GPL v3 license file
• MissingData.xls: example file for testing the interpolation function
• UserManual.pdf: user manual with a tutorial to begin the use of the software

If you have questions, bug reports or suggestions on improvement, please put them into the issue tracker or contact Howard Cheung directly by email at howard.at (at) gmail.com.

Changelog from v0.3.0-alpha

• Add output of time as values of seconds, minutes, hours or days from the user-defined start time

Data Preprocessing Helper (Pre-release v0.3.0-alpha)

Introduction

This is a pre-release of the software Data Preprocessing Helper to help people cleaning time-of-change data by converting them into appropriate spreadsheet files with constant time intervals. The development is currently conducted on 64-bit Windows machines only so only binaries of 64-bit Windows machines are available. There are six files in the zip file

• Changelog: change log from the previous version (v0.2.2-alpha)
• DataPreprocessorHelper.exe: the executable with the graphical user interface
• ExampleTimeofChangeData.csv: example dirty file
• License.txt: GPL v3 license file
• MissingData.xls: example file for testing the interpolation function
• UserManual.pdf: user manual with a tutorial to begin the use of the software

If you have questions, bug reports or suggestions on improvement, please put them into the issue tracker or contact Howard Cheung directly by email at howard.at (at) gmail.com.

Changelog from v0.2.2-alpha

• Process multiple worksheets in xls/xlsx files simultaneously
• Fill columns with invalid data only by blanks and show warnings during the process
• Change the error dialog box so that the error messages can be copied
• Load csv files with separator ";" or tabs correctly
• Can autodetect starting time from file
• Remove opening file error for xls/xlsx files dur to time string format
• En/disabling GUI options for different input/output files to avoid erroneous user inputs

Data Preprocessing Helper (Pre-release v0.2.2-alpha)

Introduction

This is a pre-release of the software Data Preprocessing Helper to help people cleaning time-of-change data by converting them into appropriate spreadsheet files with constant time intervals. Currently, the development is only conducted on 64-bit Windows machines and hence only binaries of 64-bit machines are available. There are six files in the zip file

• Changelog: change log from the previous version (v0.2.1-alpha)
• DataPreprocessorHelper.exe: the executable with the graphical user interface
• ExampleTimeofChangeData.csv: example dirty file
• License.txt: GPL v3 license file
• MissingData.xls: example file for testing the interpolation function
• UserManual.pdf: user manual with a tutorial to begin the use of the software

If you have questions, bug reports or suggestions on improvement, please put them into the issue tracker or contact Howard Cheung directly by email at howard.at (at) gmail.com.

Changelog from v0.2.1-alpha

• Change interface so that no elements overlap in Windows 10