Will Python Replace or Kill VBA?

Published: 14 July 2021
on channel: Programming Is Fun

8,461

139

Will Python Replace or Kill VBA?

Hi Guys, In this video we are talking about Python vs VBA. Python has become very popular programming language in almost all the areas. First of all Python Programming is a general purpose programming language, so it means this programming is not created for a specific purpose like VBA, people and companies are using Python to evaluate their business and heavily using in AI, Data Science, Machine Learning, Web Development, GUI Development, Data Analysis, Data Visualization, Web Scrapping, Testing, IOTs etc.

Using Python programming you can easily automate any kind of work which is based on Microsoft Excel. In this video you will look at how Python programming is far better as VBA Programming.

The videos cover the following:

Comparison of Python and VBA
What are Python and VBA used for?
Writing Code - Python vs VBA
Execution of VBA script on certain task
Execution of Python script on the same task
Evaluate the performance between Python and VBA
How to evaluate the time on the same task using Python and VBA?
How Python covers all the area?
Will Python Replace or Kill VBA?

You can find all the files and code on below link.
https://github.com/AbhisheakSaraswat/...

Python Script:
import xlwings as xw
import time
import numpy as np
import pandas as pd

start = time.time()
wb = xw.Book(r"C:\Users\AEPAC\Desktop\VBA Performance.xlsm")
sht = wb.sheets['Sheet1']
arr = np.zeros(shape=(10,100))
for i in range(1,11):
for j in range(1,101):
arr[i-1][j-1] = i * j
sht.range("A1").options(expand='table').value = arr
end = time.time()
print(end-start)

2nd Task:

%%time
pth = r"C:\Users\AEPAC\Desktop\test"
sales = pd.read_csv(r"C:\Users\AEPAC\Desktop\Sales Data.csv")
for st in sales["State"].unique():
df = sales[sales["State"] == st]
df.to_csv(pth + "\\" + st + ".csv",index=False)

VBA Script: https://github.com/AbhisheakSaraswat/...

Sales Data.csv : https://github.com/AbhisheakSaraswat/...

Python Teaser:    • A Beautiful Python Programming Teaser | In...

Python Pandas Tutorial:    • Python Pandas Tutorial | What is Pandas | ...

Python Playlist:    • Python Tutorial for Beginners

Python Data Structure Playlist:    • Python Data Structure

Python OOPs Playlist:    • Object Oriented Programming Tutorials Usin...

Python Excel Automation:    • Excel Automation Using Python

On this page of the site you can watch the video online Will Python Replace or Kill VBA? with a duration of hours minute second in good quality, which was uploaded by the user Programming Is Fun 14 July 2021, share the link with friends and acquaintances, this video has already been watched 8,461 times on youtube and it was liked by 139 viewers. Enjoy your viewing!

6,514

539