Skip to main content

'Python program that visualizes data from a .csv file.'

Project description

Project logo

V. 0.1.7


Project Description

A python program that visualizes data from a .csv file. It uses the PySimpleGui python library for its GUI.

At the moment, this program can only read data from .csv files, but in the future I plan on adding support for other filetypes, and an option to connect to a SQL or a MongoDb database.

Table of Contents

Features

If you want to test the program yourself, I recommend you visit the page mockaroo to get some sample data in .csv format.

Display data

gif-display-data

Search data

gif-search-data

Filter data

gif-filter-data


Installation

Using pip

Data visualizer can be installed with pip, along with all the program dependencies in the case they aren't installed. To do so, run the follow command:

pip install data-visualizer

From source

On the other hand, if you want to, you can also download the program from the repo. If you want to do so, follow these steps to do so.

  1. Clone the repo into your local machine:
gif-clone-repo

  1. Open the cloned folder and run the "data_visualizer" folder as a module with the following command:
python3 -m data_visualizer

Usage

There are several ways in which you can open the program.

Pip

If Data Visualizer was installed with pip, you can run the program in the terminal by simple writing data-visualizer in the terminal. The program will then open.

Manually

Another way you can run the program is by opening either the module folder installed by pip, or the cloned folder from the repo. Then, once inside the folder, simply run the data_visualizer folder as a python module with the following command:

python3 -m data_visualizer

Dependencies

PySimpleGui

By default, Data Visualizer's setup.py file was setup in a way that automatically downloads all the packages the program uses and depends of. However, if for some reason you want to install them yourself, Data Visualizer requires the PySimpleGui library to work.

You can install them with pip using the following commands:

pip install PySimpleGUI

In the case that you don't have pip, scroll down to the Pip Instalation section to see how to install it.


Tkinter

Data Visualizer is made using the PySimpleGui library, which uses Tkinter under the hood. So, it is very important to have Tkinter already setup to your Python version for Data Visualizer to work.

If you don't have Tkinter already with your Python configuration, you will need to do that first.

  • Windows: Follow this video guide.
  • MacOs (Using Homebrew): brew install python-tk
  • Linux (Ubuntu): sudo apt-get update && sudo apt-get install python3-tk

Pip installation

Don't have pip? You can install it like this:

Linux & MacOs

python3 -m ensurepip

Windows

py -m ensurepip

Please note that the installation of pip in windows can sometimes be... complicated. If you are having problems making pip work, I recommend you this video guide on how to install it.

File Support

Data visualizer supports the following types of files:

File Type Support
.csv
.json
SQL 📅
Mongodb

Keywords: ✅ Yes, ❌ No, 📅 work in progress

Header bug

Currently, there's a bug where the first row of header-less .csv files gets confused for the file's headers. This happens because Data Visualizer always takes the first row of a .csv file that comes with pre-defined headers, and uses it as the headers of the file. The usefulness of this feature can be seen with files that has its data pre-categorize in the forms of these headers. However, for files that don't do this , this feature becomes a problem.

The nature of this bug makes it pretty difficult to fix, but with time, I think I'll be able to get it done. So, keep that in mind while working with files wihout a proper header for the time being.

Bug example

Note: The files used in this example were taken from mockaroo.


File with pre-defined headers

example of file with headers

File without pre-defined headers

example of file without headers

License

This project makes use of the MIT license. To read more about it, you can check it out here.

PySimpleGui

This project makes uses of the PySimpleGui python library, which makes use of the LGPL-3.0 license. Read more about this license in the project repo here.

Project details


Download files

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

Source Distribution

data-visualizer-0.1.8.tar.gz (14.1 kB view hashes)

Uploaded source

Supported by

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