Skip to main content

Data entry and retrieval

Project description


Current dependencies


pip install PyQt5


pip install pandas

Excel for Pandas:

pip install xlrd

For writing Excel sheets

pip install xlwt

For connecting to MySQL databases

pip install mysql-connector-python

For Excel sheet editing:

pip install openpyxl

For graphical representation

pip install matplotlib

Possible Installs and Configurations

Sudo Installs for the QC library to work with OpenGL

I set up by Ubuntu WSL the same way as instructed at the beginning of the class. However, after packaging the program, there were some issues interally with the Linux system. There were errors that were given in relation to not being able to find "xcb" and not finding some files. I had to do the following to fix this error:

sudo apt-get install libxcb-icccm4-dev libxcb-image0-dev libxcb-shm0-dev libxcb-keysyms1-dev libxcb-render-util0-dev libxcb-render0-dev libxcb-xfixes0-dev libxcb-xkb-dev libxkbcommon-x11-dev libxkbcommon-dev libxcb-xinerama0-dev

This will have to be installed before the program can be ran, IF a xcb error is produced.


Again, VcXsrv was set up just the way as instructed in class. However, I was getting the following libGL (library for OpenGL) errors: libGL error: No matching fbConfigs or visuals found libGL error: failed to load driver: swrast

I found that it was a configuration with the server. I did the following options for setting up the VcXsrv server and it fixed the OpenGL errors: 1. Choose Multiple Windows 2. Set Display to the value 0 3. Choose the Start No Client option 4. Disable the Native OpenGL option.

In class, our config files keep the display value to -1 and the Native OpenGL option is Enabled. When I changed these two options, the libGL errors went away. These errors could cause problems in the display.

This will have to be changed before running the program, or it could possible cause errors with the UI.

MySQL Configuration File (LATER)

The MySQL connector looks for a configuration file called mysql.conf. It should specify host, database, user, password, and port information for the target database.

The package should install all dependencies.

Our project specifications have changed by the "customer" of this project just recently (6/27). This config will be added at another time.

GitHub Link


pip install KetoGator==1.0.16

Executable line


Username and Password

Username: user Password: password


Joseph: Did the back end portion of the project, along with creating deidentified data and porting it to a database. Kyler: Did the UI and all the logic and design to it. Roberto: Did the research necessary for the interface and read/write to the OneDrive for the professor's team. Also helped with coding the graphs. Dain: Did all research necessary for packaging the project, ensuring compatibility, and coded the graphs based on existing R code.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for KetoGator, version 1.0.16
Filename, size File type Python version Upload date Hashes
Filename, size KetoGator-1.0.16-py3-none-any.whl (313.5 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size KetoGator-1.0.16.tar.gz (269.4 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page