How to work with pandas, create, manage and visualize dataframes
In this video tutorial we will show you how to: – Work with Pandas library – Create data frames (DataFrame)…
Video Tutorials
Read More
How to work with SQL server database and queries in Python using pyodbc
In this video tutorial we will show you how to: – Connect Python with SQL Server – Create tables using…
How to create databases and tables. Use select, insert, delete, update commands etc.
In this video tutorial, we will show you how to connect SQL Server Management Studio to an SQL Server, then…
Data Scraping from web using Selenium, WebDriver and XPath
In this video tutorial we will show you how to install Selenium, WebDriver-Manager and how to use them to get/scrape…
Pivot Tables, Pivot Charts Filters and Slicers
In this video tutorial we will show you how to create pivot tables and pivot charts. How to use slicers,…
How to use World Bank API (WBGAPI) and Pandas to import data, and draw charts
In this video tutorial we will teach you how to use World Bank API (WBGAPI) to import data and statistics…
How to use COUPDAYBS/COUPDAYS/COUPDAYSNC to calculate number of coupon days
In this video tutorial we will show you how to calculate number of coupon days using COUPDAYBS, COUPDAYS and COUPDAYSNC…
How to install Power BI Desktop and create your first Chart
In this video tutorial we will show you how to install Microsoft Power BI Desktop for free and how to…
Easiest way to download, install/setup and use python (WinPython Tutorial)
Today we will show you how to download, install and use WinPython which is the most easy and portable version…
How to use AMORDIGRC function to calculate depreciation
AMORDIGRC is used to calculate degressive depreciation. This function was created for French accounting system however after changes in their…