Strings in Python
Let’s look at strings (str) in Python. The string is one of the scalar types in Python. The […]
string
Split a Delimited String in a DataFrame
Are you needing to split a string inside a column of a pandas DataFrame? Do you want to […]
Count the Number of Rows with a Condition
Suppose you are working with a pandas DataFrame in Python. You are doing some EDA (exploratory data analysis) […]
Python Find Nth Occurrence of Char in a String
In Python, how would you find the Nth occurrence of a character (or substring) in a string? Yes, […]
Change String Case in pandas
There are several ways to change the case in a pandas String. There is upper, lower, title, capitalize […]
Data Type Conversion in pandas
Convert Strings to Floats This post discusses one of the EDA Structuring tasks using Python and pandas. Here […]
EDA Discovering with Pandas
Exploratory Data Analysis has six phases: discovering, structuring, cleaning, joining, validating and presenting. The first phase is discovery. […]
Convert a String to a Date in R
In R language, if you have a string that you need to convert to a date, try this. […]
Removing Spaces in R
Sometimes you have extra spaces in your text string. You need to clean that up. trimws() removes leading […]
Excel Find Nth Occurrence of Char in a String
In Microsoft Excel, what formula would you use to find the Nth occurrence of a character (or string) […]
SQL Find Nth Occurrence of Char in a String
T-SQL’s CHARINDEX() function is useful for parsing out characters within a string. However, it only returns the first […]
T-SQL Parsing Into Many Columns
This post is about working with one column in a SQL Server table that contains a comma-separated list […]