Excel into Python (pandas)Do you have some data in Excel that you would like to import into Python? You can do […] November 10, 2024 in Python tagged excel / export / import / read / python / pandas / to_excel by Mike
AES-256 EncryptionThis is just a very quick introduction to AES-256 Encryption. The Advanced Encryption Standard (AES), originally adopted by […] November 9, 2024 in Programming tagged bit / encryption / secure / 256 / aes by Mike
Fiero CodeWhat is Fiero Code? Fiero is an all-in-one learn-to-code solution that provides everything you need to deliver coding […] May 23, 2024 in Programming tagged code / library / learn by Mike
Add New Column of Incremental Numbers in pandasAre you working with a pandas DataFrame and do you want to add a new column of incremental […] April 9, 2024 in Python tagged add / column / rank / range / rating / rate / pandas / new / order / reorder / sort / incremental / pandas DataFrame by Mike
Cleaning Mixed Data TypesExploratory Data Analysis (EDA) has six main practices. The six main practices of EDA are discovering, structuring, cleaning, […] April 8, 2024 in Python tagged excel / clean / read / pandas / cleaning / Pandas EDA Cleaning by Mike
Use isinstance to Check Data TypeAre you a data professional working with a pandas dataset and have you found that one or more […] April 7, 2024 in Python tagged isinstance / custom / data / function / type / object by Mike
Display All of the Columns in a DataFrameAre you working with pandas in a Python project? It can be very helpful to ensure that all […] April 6, 2024 in Python tagged pandas / dataframe / option / display / columns / max / show / dataset / all / pandas DataFrame by Mike
Encode Category to Ordinal NumericFor this example, I will use Python. Are you a data professional working with a dataset that contains […] April 6, 2024 in Python tagged ordinal / categorical / pandas / dummy / category / encode by Mike
Correlation Heatmap in PythonA heatmap is a type of data visualization that depicts the magnitude of an instance or set of […] April 6, 2024 in Python tagged visualization / create / chart / python / correlation / seaborn / heatmap / data by Mike
Python’s None and pandas’ NaNIn Python, the built-in value for null is None. To experiment with this I have created a Jupyter […] April 4, 2024 in Python tagged null / None / NaN / empty by Mike
Split a Delimited String in a DataFrameAre you needing to split a string inside a column of a pandas DataFrame? Do you want to […] April 4, 2024 in Python tagged split / delimited / pandas / comma / string / parse by Mike
Parse a String in PythonDo you need to parse a delimited string in Python? Is you string comma-delimited? Are there several strings […] April 3, 2024 in Python tagged parse / python / split / delimited / pandas / comma by Mike