Skip to content

| Phonepe_Pulse | Git-hub Clone | SQLite-3 | Pyplot | Streamlit |

Notifications You must be signed in to change notification settings

dhanavasanth/Phonepe_Pulse

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

64 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

phonepe_readme.mp4

Phonepe_Pulse Data Visualisation using "SQLite"

Coding

Deployment

To deploy this project run

  import streamlit as st
  from PIL import Image
  import os
  import json
  from streamlit_option_menu import option_menu
  import subprocess
  import plotly.express as px
  import pandas as pd
  import sqlite3
  import requests

Cloning phonepe pulse Repository

  response = requests.get('https://api.github.com/repos/PhonePe/pulse')
  repo = response.json()
  clone_url = repo['clone_url']

  repo_name = "pulse"
  clone_dir = os.path.join(os.getcwd(), repo_name)

Creating Data-Tables

After Cloning Git-hub create a corresponding DataFrame of given pulse data's and insert it into SQL database and create diffrent tables for diffrent aggregated data's

screen_table

Create SQL queries to fetch corresponding Data's

SELECT * FROM "Table"
WHERE "Condition"
GROUP BY "Columns"
ORDER BY "Data"

Let's have some visualizations with streamlit - webpage

Home

Home

About pulse

about

Top Queries

top queries

Customized Queries

customized queries

Support

For support, email : [email protected]

Releases

No releases published

Packages

No packages published

Languages