Skip to main content

Posts

Showing posts from August, 2025

Chanage Data source in power Bi with Advance editor

Ref Video :   https://www.youtube.com/watch?v=Fd2tU-qull8 STEP-1 - > Go to power query editor STEP-2 -> click on the table you want to change the data source STEP-3 - > go to advance editor, copy the code in advance editor of the data source which needs to changed as data source STEP-4 -> past this code in the table advance editor which you want to change
Post a Comment
Read more

How To Calculate Intrinsic Value

Link to the Video-   https://www.youtube.com/watch?v=d0EBO-vs0GM
Post a Comment
Read more

Sending Email from Python

  import  smtplib, ssl from email.mime.multipart import MIMEMultipart from email.mime.text import MIMEText from email.utils import formatdate from datetime import datetime # Convert DataFrame to HTML html_table = df_errormessage.to_html(index= False ) # Custom statement custom_statement = "<p>Please find the below error data:</p>" # Combine statement and HTML table email_body = f" {custom_statement} <br> {html_table} " # Get current date current_date = datetime.now().strftime( "%Y-%m-%d" ) smail = 'do.not.reply@company.com' tmail = [ '123@company.com' , '456@company.com' ] sub = f'Error Report - {current_date} ' def send_mail ( send_from, send_to, subject, text, isTls= True ): msg = MIMEMultipart() msg[ 'From' ] = send_from msg[ 'To' ] = ',' .join(send_to) msg[ 'Date' ] = formatdate(localtime= True ) msg[ 'Subject' ] = subjec...
Post a Comment
Read more

Setting environmental variables using .env file in Python

 STEP-1 - Finding the Root path of your python code https://stackabuse.com/bytes/get-the-root-project-directory-path-in-python/ import os # Get the current working directory cwd = os.getcwd() print(cwd) Output STEP-2 -Creating Env files After getting root path folder, create a file names .env file in that folder as shown below STEP-3 -Entering credential details in .env File you can enter all the secure details in env file as shown below.
Post a Comment
Read more

You tube channels for US Stock Investing

Everything Money Youtube channel  https://www.youtube.com/@EverythingMoney/videos The Only 3 ETFs I'd Buy If I had to start over in 2025 https://www.youtube.com/watch?v=9Twl1_dh1UI BusinessWithBrian  Youtube channel https://www.youtube.com/watch?v=xU8Cg0YTK0w Rick D'Agostino Youtube Channel https://www.youtube.com/watch?v=hOJdg8Kbvis
Post a Comment
Read more

Creating Personal Remote Desktop using AWS EC2

How to create remote desktop in AWS  https://www.youtube.com/watch?v=Egn-0rv3ZCs How to transfer files with Remote Desktop Connection easily in 2025 https://www.youtube.com/watch?v=vrDLyu4IoGk Other Hosting Options https://www.youtube.com/watch?v=4Hp-diBp-2Q Other Free RDC https://kasmweb.com/ https://guacamole.apache.org/
Post a Comment
Read more

Python code to read Blob Files

  from azure.storage.blob import BlobServiceClient import pandas as pd # Azure Blob Storage connection string connection_string = 'Connection String' # Initialize the BlobServiceClient blob_service_client = BlobServiceClient.from_connection_string(connection_string) # Container names containers = [ 'b2barchive' , 'b2bbadfiles' ] # Dictionary to store DataFrames for each container dfs = {} for container_name in containers: # Get the container client container_client = blob_service_client.get_container_client(container_name) # List all blobs in the container print ( f"Listing blobs in the container: {container_name} " ) blob_list = container_client.list_blobs() # Create a list to store blob names and last modified dates blob_data = [] for blob in blob_list: print ( f"Blob Name: {blob.name} , Last Modified: {blob.last_modified} " ) blob_data.append({ 'Blob Name' : bl...
Post a Comment
Read more