Python Tutorial
Python is a verstile programming language that has gained a lot of attention and popularity. Using Python, you do things like develop web applications, desktop applications, task automation, artificial intelligence (AI), big data, data analytics, machine learning (ML), and many other things.
Python is really becoming as the leader in data science and data analytics. With so many open source libraries to choose from (Pandas, scikit-learn, NumPy, Matplotlib), learning data analysis in Python just got so much easier.
Concatenate Pandas DataFrames Without Duplicates
By default, when you concatenate two dataframes with duplicate records, Pandas automatically combine them together without removing the duplicate rows. In this tutorial I will show you how to concatenate two dataframes and leave just the unique rows.
Create a Column Stacked Graph Based On a Pandas’ DataFrame
Python and Pandas are great tools for data analysis, and Matplotlib is great for visualization. In this tutorial we are going to take a look at how to create a column stacked graph using Pandas' Dataframe and Matplotlib library.
Get Google APIs Info With Google Discovery Service API
Google has quiet many API services, from Google Sheets, Google Tasks, Vision API, Photos Album, and many more. Since Google has so many API services, sometimes it is hard to track the what APIs are avaiable, what APIs are depreciated, and what is the latest version of...
Create A Function To Construct Service Instance For Google API
When you work with most of the Google APIs (excluding AI and Machine Learning APIs), the first thing you will have to do is to create a Service instance to connect to the Google API endpoint. Since the steps to create a Service instance for Google APIs services are...
Export Google Sheets Data to Excel In Python
Google Sheets and Microsoft Excel are no doubt the two most and widely used spreadsheet software today. In this tutorial I will be showing you how to use Google Sheets API and win32com module to integrate these two applications in Python. We will be using Google...
Export Excel Data To Google Sheets in Python
Google Sheets and Microsoft Excel are no doubt the two most and widely used spreadsheet software today. In this tutorial I will be showing you how to use Google Sheets API and win32com module to integrate these two applications in Python. We will be using win32com to...
Import Google Sheet Data Into Pandas DataFrame in Python
Google Sheets undoubtedly is one the most popular spreadsheet software in the industry today. Almost everyone who use Google have used Google Sheets at some point. Google Sheets API, in my opinion, is one of the most versatile and powerful (stabled to since it is...
Export Pandas DataFrame To Google Sheets in Python
Google Sheets undoubtedly is one the most popular spreadsheet software in the industry today. Almost everyone who use Google have used Google Sheets at some point. In Microsoft Excel, there are VBA and Office for JavaScript API, but honestly, VBA is lacked the...
Google Translation API in Python For Beginners
Almost majority of people who have used Google before have used Google Translation at some point. The Google Translation API is part of the Google AI & Machine Learning Products. With Google Translation API, we can easily integrate this feature with any web or...
Create Google Sheets Service Instances in Python
The Google Spreadsheet Service instance enables your Python script to create, read, modify, and organize your Google Sheets files. Google Spreadsheets API in my opinion is one of the most complex APIs understand and manipulate. Actually, Spreadsheets (Excel for...
