esProc Desktopesproc-desktop.hashnode.dev·Sep 11, 2024#62 - Search for A Specified String across The Whole TableProblem description & analysis: We have two Excel sheets, and there are same-structure tables in the two sheets. Sheet1 ABC 1Col1Col2Col3 2foo1NA 3bar2y 4baz3bar 5foo4z 6bar5NA 7baz6foo Sheet2 ABC 1Col1Col2Col3 2foo7bar 3bar8b...excel
Shahnawaz Khanshahnawaz.hashnode.dev·Jul 10, 2024Clean, transform and load Data in Power BIToday I earned my "Clean, transform, and load data in Power BI" badge! I’m so proud to be celebrating this achievement and hope this inspires you to start your own @MicrosoftLearn journey! Keep up the great work! Click to see my new achievementdataanalytics
Aira Francolaughingatmycode.hashnode.dev·Feb 22, 2024Understanding Data WranglingIntroduction Data wrangling is like preparing ingredients before cooking a meal. Imagine you have different types of vegetables, meat, and spices. Before you start cooking, you need to wash, chop, and organize everything neatly so that you can easily...Python for Data ScienceData Science
Md Junayed Hossainjunayedhudbrac.hashnode.dev·May 21, 2023Data Cleaning and Imputation: Retaining Data Integrity with Missing Value Handling in PythonLibraries import pandas as pd Data Loading df = pd.read_csv('features.csv') df df.describe() The describe() function in Pandas provides descriptive statistics of a DataFrame or Series. When applied to a DataFrame, it calculates and displays vari...256 readspandas
Isaac Onyeakagbuisaacwrites.hashnode.dev·May 16, 2023Understanding Data Cleaning and Preprocessing: A Beginner's GuideINTRODUCTION Welcome to the world of data cleaning and preprocessing! In data analysis, a crucial step forms the foundation for accurate and reliable insights: data cleaning and preprocessing. If you're new to this exciting field, fear not! This begi...13 likes·94 readsMachine Learning
nora imologomheforSH 7.0 Data Analytics BootCampdataanalyticsteam5sh7.hashnode.dev·Apr 15, 2023We Analyze Junk TooTABLE OF CONTENT Team Introduction Objective Business Problem Process Insight and Findings Recommendation and Conclusion Dashboard Introduction After the Side Hustle Internship 7.0 program, 7 strangers were paired to form the Data-Analysis-T...7 likes·93 readsdata analysis
