Statsmodels in Pythonstatsmodels is a Python library for fitting many kinds of statistical models, performing statistical tests, and data exploration […] September 1, 2023 in Python tagged library / regression / stats / ols by Mike
Filter Out Missing Data in PandasThere are a few ways to filter out missing data in Python. When we talk about filtering data […] September 1, 2023 in Python tagged drop_na / delete / remove / drop / null / filter / missing / NA / dropna / nulls / data by Mike
Google ColabWhat is Google Colab? Google Colab is a cloud-based service that allows you to write and run code […] August 27, 2023 in Python tagged Google / colab by Mike
Python in ExcelPython is now inside Microsoft Excel. Really? Python is only in Excel if you have Microsoft 365 on […] August 27, 2023 in Excel / Python tagged excel / python by Mike
Rename a DataFrame Column in PythonAs a data professional do you have a Python dataset that might require some column renaming? Why would […] August 5, 2023 in Python tagged name / friends / update / renaming / python / field / change / snake / rename / pandas / dataframe / case / unnamed / column / inplace by Mike
Reorder pandas DataFrame ColumnsTo reorder columns in a Pandas DataFrame, pass into the DataFrame a list of column names in the […] August 5, 2023 in Python tagged sequence / select / columns / pandas / dataframe / reorder / drop / pandas DataFrame by Mike
Groupby Multiple ColumnsHow do you take a pandas DataFrame of data (dataset) and produce a multi-column bar chart? You can […] August 4, 2023 in Python tagged group / by / plot / pandas / aggregate / groupby / column / seaborn / chart / matplotlib / bar / barplot / graph / Pandas EDA Structuring by Mike
Apply a Custom Function to a DataFrameHow do we apply a custom Python function to a column in a pandas DataFrame? Here we’ll use […] August 3, 2023 in Python tagged progress / series / custom / dataframe / function / strip / new / assign / lambda / tqdm / add / column / apply / bar by Mike
Python Find Nth Occurrence of Char in a StringIn Python, how would you find the Nth occurrence of a character (or substring) in a string? Yes, […] August 3, 2023 in Python tagged locate / find / char / string / python / substring / nth / occurrence by Mike
Change String Case in pandasThere are several ways to change the case in a pandas String. There is upper, lower, title, capitalize […] August 3, 2023 in Python tagged lower / title capitalize / swap / string / case / upper / series / str by Mike
Sorting a pandas DataFrameYou can sort a pandas DataFrame by one or multiple (one or more) columns using sort_values() method and […] August 2, 2023 in Python tagged pandas / dataframe / ascending / descending / sort / sorting / multiple / columns / pandas DataFrame by Mike
Data Type Conversion in pandasConvert Strings to Floats This post discusses one of the EDA Structuring tasks using Python and pandas. Here […] August 2, 2023 in Python tagged strip / data / million / convert / billion / replace / astype / string / comma / type / conversion / float / dollar / Pandas EDA Structuring by Mike