phonepe_readme.mp4

Phonepe_Pulse Data Visualisation using "SQLite"

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

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

About pulse

Top Queries

Customized Queries

Support

For support, email : danavasanth@gmail.com