History of Data EngineeringIn the early 2010s, we had huge increases in data volumes, velocity, and variety leading to the term […] August 10, 2023 in Data Engineering tagged data / history / engineering / DBA by Mike
Data Science CareersSome data science careers or job titles are: data scientist, data analyst, business intelligence analyst (BI), project manager, […] August 10, 2023 in Data Science tagged analyst / scientist / data / job / career / BI / science by Mike
Data Engineering IntroductionData engineering is the practice of designing and building systems for collecting, storing, and analyzing data. It’s about […] August 10, 2023 in Data Engineering tagged introduction / engineering / ETL / overview / data by Mike
Data Analytics Portfolio ProjectsAre you looking to start a career in data analytics? Are you looking for some portfolio project ideas? […] August 5, 2023 in Data Analytics tagged data / analysis / portfolio / analyst / projects / resume 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 replace / astype / string / comma / type / conversion / float / dollar / strip / data / million / convert / billion / Pandas EDA Structuring by Mike
PostgreSQL IntroductionPostgreSQL is a very popular open-source database platform. The homepage says: “PostgreSQL is a powerful, open source object-relational […] July 23, 2023 in Database tagged data / database / PostgreSQL by Mike
Describe method in PandasThe describe() method can be used on a pandas DataFrame. describe() returns descriptive statistics of only columns of […] July 21, 2023 in Python tagged max / min / describe / quartile / data / MEAN / statistics by Mike
Missing Data in PandasExploratory Data Analysis (EDA) has six main practices. The six main practices of EDA are discovering, structuring, cleaning, […] July 10, 2023 in Python tagged EDA / None / NaN / abscent / data / NA / null / isnull / sum / values / missing / Pandas EDA Cleaning by Mike
Manually Create a pandas DataFrameA DataFrame is a rectangular table of data with an ordered, named collection of columns. Each columns has […] July 6, 2023 in Python tagged dataset / fake / dataframe / manually / data / sample / create / people / pandas DataFrame by Mike
How to Become a Data AnalystHow does one become a data analyst? How do you get into the field when you are coming […] July 4, 2023 in Data Analytics tagged job / career / analytics / skills / analyst / data / analysis by Mike
The PACE FrameworkThe PACE framework is a framework by Google for data analysis and machine learning projects. PACE is an […] June 28, 2023 in Data Analytics tagged framework / plan / methodology / analysis / workflow / analytics / steps / data / project by Mike
2 Exploratory Data Analysis OverviewExploratory Data Analysis (EDA) is a very important process for the data analytics professional because you cannot do […] June 19, 2023 in Data Analytics tagged data / analysis / introduction / basics / EDA / exploratory / overview by Mike