Skip to content

This project facilitates users to retrieve PhonePe transaction and user data, store it in a MySQL database. Subsequently, the stored data is visualized in a Streamlit web application using Plotly and Pandas DataFrame.

Notifications You must be signed in to change notification settings

Gokulakkrizhna/PhonePe-Pulse

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Phonepe Pulse Data Visualization and Exploration:A User-Friendly Tool Using Streamlit and Plotly

Overview

PhonePe Pulse Data Visualization is a project aimed at analyzing and visualizing transaction data and user behavior on the PhonePe platform. The project utilizes Python libraries such as Pandas, Plotly, and Streamlit to retrieve, process, and visualize the data which is stored in a MySQL database. Through interactive visualizations, we can gain insights into various aspects of PhonePe transactions, including transaction trends, transaction types, user demographics, geographic analysis, and more.

Table of Contents

Key Technologies and Skills

  • Python Scripting
  • Streamlit
  • Data Cleaning and analysis
  • Pandas-Dataframe
  • Database management using MySql
  • Data visualization using Plotly

Installation

To run this project, please install below python packages as prerequisites and download git from below mentiond link.

Git - (https://git-scm.com/downloads)

pip install streamlit
pip install mysql-connector-python
pip install pandas
pip install pymysql sqlalchemy
pip install plotly
pip install numpy

Usage

To use this project, Please follow the below steps.

  • To clone the PhonePe Pulse data:git clone https://github.com/PhonePe/pulse.git
  • To clone this repository: git clone https://github.com/Gokulakkrizhna/PhonePe-Pulse.git
  • Install the required packages: pip install -r requirements.txt
  • To extract data and store in Mysql:python Datacoll_dataclean.py
  • Run the Streamlit app: streamlit run Dataextract_visual.py
  • Access the app in your browser at http://localhost:8501

Features

  • Fetch PhonePe transaction and user data from Github
  • Data Cleaning and pre-processing
  • Store data in a MySQL database
  • Analyzing the data with the help of SQL queries
  • Visualize data using Plotly and Pandas DataFrames
  • User-friendly interface powered by Streamlit

Approach

Data Collection: Clone the PhonePePulse data from the GitHub repository to your local directory, ensuring seamless access.

Data Cleaning: Refine pre-processing methods like Data handling is applied to the collected data.

Store data in MySql: The collected data is stored in a MySQL database. Employ the MySQL Connector package to establish a connection with the MySQL localhost server.

SQLAlchemy and PyMySQL: These 2 will facilitate the creation of a temporary connection to the MySQL database, enabling bulk insertion of data.

Setup the Streamlit app: Streamlit is a user-friendly web development tool that simplifies the process of creating intuitive interfaces. With Streamlit, you can easily design a straightforward UI where users can select a type of data and quickly access all relevant details in a simple manner.

Data Analysis: Using SQL queries, the retrieved data has been analyzed and visualized in Streamlit through Pandas DataFrame.

Data Visualization: The retrieved data has been visualized using Plotly to gain valuable insights from the datasets.

The provided code utilizes Python scripting along with various libraries to fetch data from the PhonePe Pulse GitHub repository. Data handling procedures are applied, and the processed data is stored in a MySQL database. Subsequently, the stored data is utilized for data visualization to gain valuable insights. Additionally, it incorporates a Streamlit web application to facilitate user interaction.

Here's a breakdown of what the code does:

  • Importing all the neccessary libraries includes Streamlit which creates UI to interact with user and display the analysed data, Pandas which helps to display the analysed data in Streamlit web,mysql-connector-python will create a connection between python and MySql server,numpy which will help in mathematical conversion,Plotly is employed to visualize the data and gain insights from it,OS assists in reading data from the local directory,JSON is used to load JSON files into Python,pymysql sqlalchemy will create a temporary connection with MySql database for a bulk insertion.
import os
import pandas as pd
import json
import numpy as np
import mysql.connector
from sqlalchemy import create_engine
import streamlit as st
import plotly.express as px
from plotly.subplots import make_subplots
import plotly.graph_objects as go
  • Datacoll_dataclean file is responsible for fetching data from the local directory and performing necessary data cleaning operations. Once the data is cleaned, it will be stored in a MySQL database using SQLAlchemy.Note: Replace your actual path in path
path = r"please provide the path"
  • Dataextract_visual file is used to extract the data stored in MySQL and visualize it to derive valuable insights using Plotly.
  • Five separate tabs have been implemented in the Streamlit web application to facilitate user interaction and enhance data visualization for insightful analysis.
tab1, tab2, tab3, tab4,tab19= st.tabs(["Home", "Data visualization", " Statistics Data","Transaction Insights","User Insights"])
  • In Tab1 of the Streamlit web application, user can select type of Data, Year and Quater for which they need to visualize the data in Geo visualization.
  • In Tab2 of the Streamlit web application, user can select the type of plot they need to visualize the retrieved data.
  • In Tab3, statistical data has been analyzed and visualized, closely resembling the PhonePe Pulse visualization.
  • In Tab4, all transaction-related data has been retrieved, analyzed, and visualized to glean insights from the data.
  • In Tab19, user-related data has been collected, analyzed, and visualized to extract valuable insights.

This Python script facilitates seamless data retrieval from a local directory, conducts essential data cleaning processes, and efficiently stores the cleaned data in MySQL. Subsequently, it retrieves the stored data from MySQL, enabling comprehensive analysis and visualization through dynamic Geo-visualization techniques. This comprehensive approach empowers users to glean valuable insights and make informed decisions based on the visualized data.

Contact

📧 Email: gokulakkrizhna@gmail.com

🌐 LinkedIn: linkedin.com/in/gokulakkrizhna-s-241562159

For any further questions or inquiries, feel free to reach out. We are happy to assist you with any queries.

About

This project facilitates users to retrieve PhonePe transaction and user data, store it in a MySQL database. Subsequently, the stored data is visualized in a Streamlit web application using Plotly and Pandas DataFrame.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages