Development Online Course by Udemy, On Sale Here
Master yourself to automate Industry-level datasets in Excel with hands-on experience on “2 Case Studies” using Python
An excellent training about Software Engineering
Automate Excel using Python – Xlwings Series 1
This course teaches how to automate Industry-level datasets maintained in Excel sheets using Python programming language. MSExcel is a very helpful tool for record-keeping. But the language that comes by default for macro is VBA, which is dated. And in the field of Data Analysis, Python has a lot of interesting packages which makes a job easy. Package like xlwings links any Excel with Python macros. Packages like Pandas, takes data into tabular format and also has customized filtering of rows or columns for complex data analysis. Packages like Matplotlib, Plotly enables to create different plots – line plot, Scatter plot, Heat map for finding the correlation b/w different parameters. In the Series, 2 Case studies has been picked from Industry process line. And correspondingly, Python macros are created to: reduce time in analysisenable customization using python packagesreduce macros code lines in VBA codebase. create customized User-defined modules by python functions. The Series-2 is also available now in the Instructor’s profile.
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.