Data Analysis and Manipulation in Excel Using Python Win32Com Pandas and XlWings Part 1

Data Analysis and Manipulation in Excel Using Python Win32Com Pandas and XlWings Part 1

In this video we are going to create or add excel workbook and insert values into excel worksheets using python, win32com, pandas and xlwings.

With the combination of these three python modules we can do data analysis and manipulation in excel in a great and fast way.

Python is a widely used high-level, general-purpose, interpreted, dynamic programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than possible in languages such as C++ or Java. The language provides constructs intended to enable writing clear programs on both a small and large scale.

Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles.It also supports modules and packages, which encourages program modularity and code reuse. The Python interpreter and the extensive standard library are available in source or binary form without charge for all major platforms, and can be freely distributed.

[giuliko]

Hello friend. I'm new on python programming but advanced in vba. I'm using pycharm on python, do you have any material or something you can share using pycharm and excel files? Thanks in advanced.