pjaskulski/csv_viewer

CSV files viewer (python + pyqt5 + pandas)

CSV_viewer

CSV files viewer.

The app reads local CSV files as a data frame (thanks to pandas), downloads CSV from the internet by API, exports data to XLSX, SQLite, HTML, CSV, markdown, delete rows with missing values, shows summary and info about data frame.

Requirement

• PyQt5
• Python 3.x
• Pandas
• XlsWriter
• SQLAlchemy
• requests
• argparse

Command line usage:

python csv_viewer.py [-h] -p PATH -s SEPARATOR -d DECIMAL

optional arguments:
    -h, --help    show this help message and exit
    -p PATH       Path to CSV file
    -s SEPARATOR  Separator: comma, semicolon or tab
    -d DECIMAL    Decimal point: dot or comma

example:
    python csv_viewer.py -p small_data.csv -s comma -d dot 

Screenshots: