Fedingo

How to Select Rows from Dataframe Using Column Values

Sometimes you may need to select rows from Pandas dataframe. Here is how to filter rows based on column values.

Sometimes you may need to rename columns in Pandas Dataframe. Here are the steps to change names of columns in python pandas.

There are many ways to create pandas dataframe in python. Here are the steps to do it.

There are several ways to create dataframe in python pandas. Here is how to create pandas dataframe from lists.

Sometimes you may need to access index of last element in pandas dataframe. Here are the steps to do it.

Sometimes you may need to insert or update data in MySQL table. Here are the steps to use MySQL Insert or Update.

Sometimes you may need to replace multiple strings & patterns in column in MySQL. Here is how to do regular expression replace in MySQL.

Sometimes you may need to extract number from string or numerical value from string in MySQL. Here is how to get digits from string in MySQL.

Sometimes you may need to copy file to EC2 instance without password using SCP. Here is how to use SCP with PEM file (SSH key).

cURL works with SSL certificate for HTTPS URLs. Here is how to ignore SSL certificate errors in cURL.