NPM-Analytics is a collection of tools and code snippets for data analytics, built using Python and Streamlit. This project aims to help you analyze accounting data, visualize charts, store analytics data in Google Sheets, extract phone number information, and even check your IP/location—all in one place.
- CSV Analytics & Visualization: Upload your accounting CSV file and visualize key categories (Sales, Market, Interest, Fees, Taxes, etc.) in an interactive bar chart.
- Google Sheets Integration: Place orders or save custom data directly to a Google Sheet, using built-in Google Cloud service account credentials.
- Phone Number Lookup: Enter a phone number (with country code) to get details like validity, carrier, region, and time zone.
- IP & Location Info: Instantly fetch your public IP and geolocation using IP-based APIs.
- Simple Streamlit UI: All interactive features are accessible via a clean Streamlit app interface.
- Python 3
- Streamlit for the web interface
- Pandas for CSV and data handling
- Matplotlib for plotting charts
- Google Sheets API (gspread, oauth2client) for cloud-based storage
- phonenumbers for phone number parsing
- requests for web APIs
NPM-Analytics/
│
├── NPManalytics.py # Main Streamlit app with all features
├── README.md
├── LICENSE
-
Clone the repository:
git clone https://github.com/sonuramashishnpm/NPM-Analytics.git cd NPM-Analytics -
Install dependencies:
pip install -r requirements.txt
(If requirements.txt is missing, install: streamlit, pandas, matplotlib, gspread, oauth2client, phonenumbers, requests)
-
Run the app:
streamlit run NPManalytics.py
- CSV Charting: Upload your CSV file with a 'Category' column. The app counts occurrences of each category and generates a bar chart.
- Google Sheets: Enter your company name, resource, and quantity to submit data straight to a Google Sheet.
- Phone Number Info: Input a phone number to see its location, carrier, and formatted versions.
- IP/Location: The app automatically fetches and displays your IP and geolocation.
MIT License © Sonu Kumar (Ramashish)
See LICENSE for details.
Enjoy analyzing your data with NPM-Analytics! Contributions and suggestions are always welcome.