Skip to content

Instantly share code, notes, and snippets.

View nna-emeks's full-sized avatar

Nna-Emeka OKEKE nna-emeks

View GitHub Profile

Keybase proof

I hereby claim:

To claim this, I am signing this object:

@nna-emeks
nna-emeks / gist:34b51bc5fbe14332be6caca75de64956
Created June 25, 2018 08:15
This procedure let's you manage a login page using a csv file...
__author__ = 'nnaemeka.okeke'
import csv
lname = str(input("Please enter your last name or surname : "))
with open('E:\\path\\to\\csv\\file\\customer.csv', 'r') as cust:
reader = csv.reader(cust)
col = next(reader)
nlist = []
@nna-emeks
nna-emeks / gist:be62c21c5ac641b03c75d3c3f22cbf2f
Created June 16, 2018 12:36
A simple solution to create a dashboard from csv or excel for internal consumption using Plotly dash and panda libraries
__author__ = 'nnaemeka.okeke'
import dash
import dash_core_components as dcc
import dash_html_components as html
import plotly.graph_objs as go
import pandas as pd
pd.set_option('display.width',1000)
@nna-emeks
nna-emeks / gist:44445c0032a093a26261b477db020c2e
Created June 12, 2018 11:29
A simple solution to extract a report off an Oracle database using SQL and send same with Python as a HTML table and a chart.
#SQL to extract data based on the total hits count for a specific period.
SET NEWPAGE NONE;
SET FEEDBACK OFF;
SET UNDERLINE OFF;
SET PAGESIZE 5000;
SET TRIMSPOOL ON;
spool /dir/to/destination/folder/file_name.csv append
select operate||','|| code||','|| sum(message_count)||','|| date_||','|| name