This post is about using Telegram bot to remotely control ESP32 microcontroller to on/off 4 LEDs. Please watch my YouTube video below, for better understanding
Author: AnthonyC
Pandas dataframe to Excel, retaining Excel sheet cells formatting
Hi, when we transfer a dataframe to an pre-formatted Excel sheet, there will be a common issue where the cell formatting of the Excel sheet
Create Draft Outlook Email with table using Python
This post uses Python to query a table from SQL Server, attach the table into the email body and create a draft Outlook email. Below
Jupyter Notebook shortcuts : to go to the cell that you want quickly and easily.
Jupyter Notebook has cool shortcuts where you can write it into a Markdown cell between your code. By using anchor tags with id and #
Clean data headers with Excel and Power Query
Hi, in this post, we are using Excel transpose function and Power Query to clean up our data headers to the format that we want.
3 ways to get daily percentage change for a stock price data
Hi, this post is about how you can use Python Pandas and data_reader library to extract and get the daily changes in the stock price
Welcome...enjoy coding, Electronics, IOT or data mining? Thank you for visiting my blog. 