apanasara Goto Github PK

agriapeda_web_rpa_powerbi

Extraction of port wise historical export data from Indian Agri Apeda website using Python Selenium & Panda. Further dashboard developed on Power Bi.

balance_sheet_powerbi

Balance Sheet Simulation

crypt_mqtt_modbus_wifimanager

Arduino sketch for communication between RS485-ModbusRTU device to Web-Server thru encrypted MQTT. Additionally, WiFi Manager feature helps to configure WiFi Node on field.

cv_powerbi

Interactive Resume template made in Power Bi

distribution_curve_sergemntation_with_sum_100percnt

Excel VBA Macro for Segmenting Distribution curve so that sum up with 100%. This can be helpful in planning package for resource loading.

email_rpa

Extracting data from eMail box using Pyhon libraries like imaplib, email & panda

figure_to_multilingual_words_currency

VBA Macro (Ms Excel) is developed to 'spell the Amount'. It is basically number to words conversion. Current file covers FRENCH and ENGLISH library for spelling.

filter_current_column

VBA-Macro to enhance productivity thru Excel-Data-Filtering into current column.

geolocationencoding

Encoding Decoding of Geo Location for compactness for easy-in-sharing location

gis_logistic_pre-route-survey

A GIS utility to identify the hurdles before surveying the route for movement of ODC (Over Dimension Cargo) / OWC (Over Weight Cargo). By using this tool, surveyor can get bottle necks to be taken care.

modbusmasterfp

Arduino Library for ModbusRTU Master communication with Function Pointer architecture so that functions can be called as function into classes. Main idea behind introducing FP is to call method(function) of ModbusMaster Class into other Class.

multiple_waterfall_stackchart_powerbi

numpy_stock_candlestick

To summarize data for candlestick, numpy is great approach for aggregation.

open_spreadsheet_writer

Writing Spreadsheet having merge fields by using xml libraries. Spreadsheets are in Open spreadsheet format. Hence, it can be opened into Ms Excel, Liber Office etc.

powerbi-sigmoid

To learn-n-fun by implementing Sigmoid function using DAX

previous_vs_current_powerbi_visual

Visual that compare previous & current KPI values on gradient band. This custom visual was build to get learnings.

saruss_3x3_determinant

Faster & memory efficient approach to compute 3x3-Determinant thru applying Sarrus' Rule

skyline-chart

VBA Application which uses Excel Stack Chart & renderinng skyline chart like 'Chart-in-Chart'

solar_roof_top

Solar PV Array Installation project

spline_intersection_in_chart

Finding Intersection Points of Two Splines in Chart for further randering

student_performance_powerbi

Student Performace Dashboard

text-summarizer_web

Summarizes Text

topn_highlight_powerbi

tweet_sentiments_r

edx : HarvardX: PH125.6x Data Science: Wrangling - Text Mining

websocket_mqtt_bridge_fastapi

Connecting FastAPI server with MQTT server using Websocket.