RegEx Regular Expression inside Lambda Function in Python

*Video Link:-
https://youtu.be/fr7I2SCfTnw

*Library Package :- re

*Details:-
In this program, we searched occurance of all strings started with character 'a' from a list using regular expression inside lambda function.

*Coding:-
import re
names=['annu', 'ram', 'anant', 'mohan']
x=filter((lambda name: re.match('^a', name)), names)
print(list(x))

*Hashtags:-
#python #regex #function #coding #online

Computer Coding Class

How to Extract Images from PDF using Python

* Link:-
https://youtu.be/4wImBQ7NqeI

*Function used:- fitz.get_pixmap()

* Library used:- PyMuPDF, OS

*IDE:- Anaconda Spyder

*Python Version:- Python 3.7

*Hashtags:-
#python #pdf #image #scraping

Computer Coding Class

Extract Multiple Tables in a Word File to an Excel File using Python

*Video Link:-
https://youtu.be/h0nEQS_XJf8

*Libraries used:- docx, pandas

*Details:- here we used docx to open a word document and identify all tables. Then we created a blank dataframe using pandas. Next we read all the rows of the tables one by one and put into dataframe. We used only one dataframe for all videos. We insert an empty row after each table so that we can see all tables separately.
Next by using DataFrame.to_excel() function we converted that DataFrame into an Excel file.

*Hashtags:-
#python #pandas #tutorial #docx #excel

Computer Coding Class

How to Copy Excel Sheet in Same Excel File using Python

https://youtu.be/WDft09egNXo

#python #excel #automation #coding #programming

Computer Coding Class

How to Create Unique File Name using Python | Python Automation | Windows File System Automation.

https://youtu.be/wn9tyb1jvb0

#python #os #file #filesystem #windows #automation #tutorial #online #classes

Computer Coding Class

How to Convert DataFrame into Text File using Python Pandas

*Video Link:-
https://youtu.be/9EFhyeG-nXc

*Details:-
In this tutorial, we will convert a dataframe into a Text File using python pandas.

* Functions:-
1. import pandas library
2. Create a python dictionary with 3 records
3. Convert dictionary into a dataframe
4. Print dataframe
5. Convert dataframe into a string using to_string() function of dataframe.
6. Open a new text file in write only mode
7. Write string into text file
8. Close text file
9. Run program
10. A new text file will be created with all records of dataframe in tabular format.

* Library Packages:- python pandas

*Hashtags:-
#coding #programming #python #pandas #tutorial #learning #online #dataframe

Computer Coding Class

How to Extract Instagram account details using beautifulsoup in python

*Details:- In this tutorial, we will scrape the Instagram account details of any Instagram account without log in or password using Beautifulsoup with Python.

*Link of Youtube video:-
https://youtu.be/LsHAlryWvUs

*Hashtags:-
#python #instagram #scraping #automation

Computer Coding Class

How to Extract Instagram profile picture using beautifulsoup in python

*Details:- In this tutorial, we download the Instagram profile picture of any account in our computer system without log in or password using Beautifulsoup with Python.

*Link of Youtube video:-
https://youtu.be/TTSyOspexD4

*Hashtags:-
#python #instagram #scraping #automation

Computer Coding Class

How to Convert Excel to Image using Python | Convert Excel Table to Image Python | Excel Automation

*Video Link:-
https://youtu.be/0fxQPxvdZLM

*Details:-
In this tutorial, we will learn how to convert a particular spreadsheet into a BMP image.

* Steps:-
1. Import libraries
2. Open Excel Application
3. Open Excel file
4. Select worksheet from workbook
5. Select Range of Rows and columns
6. Copy selected data and save in clipboard
7. Grab the copied data from clipboard
8. Save copied data as image.

* Library Packages:- win32com.client, pillow

*Coding:-
import win32com.client
from PIL import ImageGrab
excel= win32com.client.open('Excel.Application')
file='abc.xlsx'
image='output.bmp'
If you want to learn rest coding then you can watch our YouTube video...

*Hashtags:-
#coding #programming #python #excel #image #automation #tutorial #learning #online

Computer Coding Class

How to Download an Instagram Profile Picture using Python | Python Instagram | Instagram Python

*Video Link:-
https://youtu.be/TTSyOspexD4

*Details:-
In this tutorial, we will learn how to download profile picture of any Instagram profile in our computer system without log in or password using BeautifulSoup in Python.

* Functions:-
1. import all necessary packages
2. Input Instagram account username
3. Set the web address of Instagram profile
4. By using urllib, Send this web address as an http request to Instagram server and server will return the raw data of Instagram profile. Save these data in a variable.
5. By using BeautifulSoup we will search the url of profile picture.
6. By using requests library, we will get the raw binary data of profile picture.
7. Create a binary image file in write mode.
8. Write all binary data into this binary file.
9. Save binay file as a .jpg image.
10. Close file.

* Library Packages:- urllib, bs4(BeautifulSoup), requests

*Coding:-
import requests
from urllib.request import urlopen
from bs4 import BeautifulSoup
url="https://www.instagram.com/{}/"
username=input('enter username=')
webadd=url.format(username)
html=BeautifulSoup(webadd, 'html.parser')
data=html.find('meta', property=:'og:image:')
If you want to learn rest coding then you can watch our YouTube video...

*Hashtags:-
#coding #programming #python #instagram #scraping #automation #tutorial #learning #online

Computer Coding Class