Category: Pandas

[Detailed] concat, join, merge dataframes in pandas & python

How to use pandas and python to merge 2 or multiple dataframes. How to do inner, outer, left, right, left_on, right_on, left_index, right_index merge. Join and concat, merge dataframes with no column in common.

How to do Exploratory Data Analysis with Pandas Profile Report

How to quickly and efficiently explore your dataset with Pandas Profile Report Function. The first thing to do with a new dataset is to explore it and get a feel and intuition for the data before you start hacking away at the data.

4 ways to load data in Jupyter notebook and visual studio code.

How to load data from CSV file, URL link, ZIP file, .TAR file in Jupyter Notebook and Visual Studio Code using Python and Pandas. How to Use WGET, import Zipfile, Import Tarfile, and other file unlocking techniques.

How to Create a New DataFrame in Python using Pandas

This tutorial will teach you how to create new columns and datasets in python using pandas for data analysis. Pandas is one of the easiest and most popular tools to create datasets.

How to Engineer a New Feature in Python Using Pandas

Before you engineer a new feature, you need to ask yourself questions like, what is the purpose of this new feature, what am I trying to accomplish with this new feature, what experiment am I running?

How to Drop and Delete a Column In Python Using Pandas

This tutorial content will teach you how to drop or delete a column from your dataset using python and pandas. To drop multiple columns, you place the columns that you want in a list.

Github Useful Notes and Commands
Follow this URL to setup SSH on windows powershell for github. delete branch locally delete branch remotely Create new git branch This is shorthand for: Make an empty commit for pushing to production. Scenario How to get it done. How to resolve a merge conflict where master branch has changed resulting in your own code being out of sync with master From the command line After setting up SSH, how to add email and username to terminal git config --global user.email "email@example.com" git config --global user.email (To confirm setting) git config --global user.name "Mona Lisa" git config --global user.name (To … Read more
How to setup SSH on Windows Powershell for github
(Steps 2 to 5 might need to be done as admin) After setting up SSH for github, you need to add your email address and username to the terminal so that you can push git changes back to remote as yourself. Follow these instructions to add email and username to terminal for github.
Programming Concepts : Object Oriented Programming (OOP) in Python
Where I talk about different programming concepts in python.
Programming Concepts
Where I write down different fundamental concepts of computer programming. Object-Oriented Programming and other concepts.
Machine Learning Concepts
My understanding and explanation of Neural network, deep learning, model parameter, hyper parameter, loss function, bias-variance trade-off, neurons, nodes, weights, and more.
Evolution of the Data Lake
Topics: Journey of data storage. [Paper Tape, Punch Cards, Magnetic Tape, Disk Storage]. Data Integrity. Data WareHouse. Data Warehouse Infrastructure. Limitations of Data Warehouse.
[SOLVED]: Invalid template path ec2_instance.yml in CircleCI
If you are working in CircleCi trying to deploy AWS stack and you get an error message that says "Invalid template path". Here is the solution: Move your template file from inside .circleci folder to the same folder level as .circleci
Terraform not creating AWS Oracle DB due to Password Error
"Problem" - Error: Error creating DB Instance: InvalidParameterValue: The parameter MasterUserPassword is not a valid password. "Solution" is to change the special field to false. Just removing the special field input doesn't work because the default value for the special field is true.
VSCode not starting in Ubuntu
Problem: Suddenly VSCode won’t open in Ubuntu WSL when you type "code ." Solution: Not sure what solved the problem, but things I tried before it started working again.
Detailed Comparison Between Kajabi VS WordPress (Updated 2022).
This comparison between kajabi and wordpress will cover SEO, Video Blogging, Social sharing, Editing blog, promoting digital business, website speed, plugins or no plugins, website security, and more factors.