Excel Column to CSVHow would you convert an Excel column of strings or numbers to a string as a comma separated […] July 6, 2023 in Excel tagged excel / list / VBA / csv / transpose / pandas / dataframe by Mike
EDA Discovering with PandasExploratory Data Analysis has six phases: discovering, structuring, cleaning, joining, validating and presenting. The first phase is discovery. […] July 4, 2023 in Python tagged string / discovering / date / columns / python / plot / subset / pandas / random / EDA / sample / discovery / replace / Pandas EDA Discovery by Mike
Duplicate Rows in PandasExploratory Data Analysis (EDA) has six main practices. The six main practices of EDA are discovering, structuring, cleaning, […] July 3, 2023 in Python tagged duplicate / pandas / print / duplicated / percent / format / duplicates / drop / unique / Pandas EDA Cleaning by Mike
Exploring Data Types in pandasExploratory Data Analysis (EDA) has six main practices. The six main practices of EDA are discovering, structuring, cleaning, […] June 17, 2023 in Python tagged pandas / EDA / structuring / dirty / cleaning / data / lambda / clean / types / Pandas Data Types by Mike
Reading in Files in PandasGetting your data into Python is likely one of your early steps in your project. That data could […] June 11, 2023 in Python tagged file / import / read / python / pandas / dataframe by Mike
Pandas DataFrames EDADo you have a small dataset (rows and columns) in an external file and you want to explore […] June 9, 2023 in Python tagged data / structure / frame / pandas / pandas DataFrame by Mike
Pandas DataFrame IntroductionA Pandas DataFrame is a two-dimensional data structure, with “rows” and “columns”, like a two-dimensional array, or a […] April 27, 2023 in Python tagged pandas / pd / dataframe / data / table / analysis / frame / pandas DataFrame by Mike
Pandas LibraryPandas is a Python library that’s used to work with data sets and analyze data. It has functions […] April 25, 2023 in Python tagged data / analytics / pandas / dataframe by Mike