- 27
- 4 201
Median Pulse
Registrace 12. 05. 2024
We help you become more data-driven at work and life!
How to "VLOOKUP" in Python using Pandas?
A common question a lot of people have is how do you perform a VLOOKUP- like operation in Python. In this video, I explain how to accomplish this using the Pandas library.
zhlédnutí: 23
Video
Withings ScanWatch Nova: Hybrid Watch for Health Data Tracking
zhlédnutí 527Před 9 hodinami
My thoughts and impressions on the Withings ScanWatch Nova Hybrid Smartwatch! 🛒 Product Links (contains affiliate links): Withings Store on Amazon (US): amzn.to/4duhHkE Withings ScanWatch Nova on Amazon (UK): t.ly/Ruo3V Brown Leather Strap 20mm: amzn.to/3WDgRuZ Black Rubber Strap 20mm: amzn.to/3SKZVBk Pine/Olive Green Magnetic Sport Band 20mm: amzn.to/3X01m1q Pine/Olive Green Buckle Sport Band ...
Linear Programming in Python with SciPy - Easy Example!
zhlédnutí 80Před dnem
In this video, I demonstrate how to use the SciPy library in Python to solve linear programming problems.
Data Cleaning 101 in Python
zhlédnutí 706Před 14 dny
In this video, I show you the process of data cleaning in Python at a basic level to help you effectively prepare your data for analysis. Outline: 0:00 - Intro 0:40 - Viewing & Understanding the Data 3:20 - Converting Data Types 4:52 - Deleting Unwanted Columns 6:11 - Renaming Columns 7:02 - Handling Duplicates 8:10 - Dealing with Missing Values 10:41 - Creating New/Derived Columns 11:50 - Reca...
Stop Doing Nested Ifs Like This - Use IFS Instead
zhlédnutí 53Před 14 dny
In this video, I show you how to use the IFS() function to easily handle nested if conditions in Google Sheets or MS Excel.
FLATTEN in Google Sheets: Combine Multiple Columns into One (3 Examples)
zhlédnutí 168Před měsícem
0:00 - Sales table example 1:45 - Country data example 3:01 - Student names example In this video, I go over three examples to show you how to use the FLATTEN() function in Google Sheets. The FLATTEN() function helps you transform tabular data or combine data from different columns into a single list.
Certified Analytics Professional (CAP) Certification Guide and Preparation Tips
zhlédnutí 104Před měsícem
0:00 - Certification Overview 3:01 - Key Topics 4:51 - Study Resources Official website: www.certifiedanalytics.org Key Topics: t.ly/uNfB5 Official Sample Test: www.certifiedanalytics.org/sample-test Official Exam Resources (Handbook, Study guide): www.certifiedanalytics.org/exam-resources Analytics Glossary: analyticsexplained.com/analytics-glossary/ Exam Preparation Guide for CAP by Rajan Gup...
Publish Google Sheets as Web Page - Fast & Easy!
zhlédnutí 40Před měsícem
In this video, I show you a fast and easy method to publish a Google Sheet as a web page. S&P 500 Live Watchlist video: czcams.com/video/5VoqTOXX5OU/video.html S&P 500 Live Watchlist Google Sheet: t.ly/IrJ8D S&P 500 Live Watchlist Published Web Page: t.ly/EwPE6
Import Data from Google Drive to Google Sheets Using Appscript
zhlédnutí 125Před měsícem
In this video, I demonstrate how to automatically import data from Google Drive to Google Sheets using Appscript.
Build a Live S&P 500 Stock Watchlist in Google Sheets
zhlédnutí 195Před měsícem
In this video, I show you how to create a live watchlist to automatically monitor the S&P 500 stock prices using the GOOGLEFINANCE() function in Google Sheets. Link to the S&P 500 Live Watchlist: t.ly/IrJ8D
2D Lookup on Matrix Data Using INDEX-MATCH in Google Sheets/MS Excel
zhlédnutí 159Před měsícem
In this video, I show you how to do a 2D (Two-dimensional) or two-way lookup on matrix/tabular data using INDEX-MATCH in Google Sheets or Microsoft Excel.
Email Google Sheets Data as CSV Using Appscript Automatically
zhlédnutí 50Před měsícem
In this video, I demonstrate how to automatically email data from Google Sheets as a CSV file to a specified email address. I also show you how to schedule this process to run hourly, daily, or at any other specified interval.
Calculated Field in Google Sheets Pivot Tables - Explained!
zhlédnutí 237Před měsícem
In this video, I explain and walk you through how to add a Calculated Field in a Google Sheets pivot table.
How to Calculate Weighted Average in Google Sheets
zhlédnutí 93Před měsícem
In this video, we learn how to calculated the weighted average in Google Sheets using AVERAGE.WEIGHTED() or SUMPRODUCT() method.
How to Create Summary Statistics in Google Sheets
zhlédnutí 76Před měsícem
In this video, I show you how to generate Summary Statistics like mean, standard deviation, etc in Google Sheets. Functions and Sample Usage: Mean: =AVERAGE(A1:A10) Median: =MEDIAN(A1:A10) Standard Deviation (Sample): =STDEV(A1:A10) Standard Deviation (Population): =STDEVP(A1:A10) Variance (Sample): =VAR(A1:A10) Variance (Population): =VARP(A1:A10) Maximum: =MAX(A1:A10) Minimum: =MIN(A1:A10) Co...
Bulk Translate Data using GOOGLETRANSLATE() in Google Sheets
zhlédnutí 127Před měsícem
Bulk Translate Data using GOOGLETRANSLATE() in Google Sheets
Two Ways to Remove Gridlines in Google Sheets
zhlédnutí 134Před měsícem
Two Ways to Remove Gridlines in Google Sheets
How to Merge CSV Files Using Pandas in Python
zhlédnutí 61Před měsícem
How to Merge CSV Files Using Pandas in Python
Import HTML web tables into Google Sheets using IMPORTHTML()
zhlédnutí 89Před měsícem
Import HTML web tables into Google Sheets using IMPORTHTML()
Insert Images Dynamically in Google Sheets Using IMAGE() function
zhlédnutí 213Před měsícem
Insert Images Dynamically in Google Sheets Using IMAGE() function
Solving Linear Programming Problems With Excel Solver Add-in
zhlédnutí 106Před měsícem
Solving Linear Programming Problems With Excel Solver Add-in
Using the PROPER function to Clean up Text Capitalization in Google Sheets
zhlédnutí 175Před 2 měsíci
Using the PROPER function to Clean up Text Capitalization in Google Sheets
How to Perform Linear Regression using Excel
zhlédnutí 78Před 2 měsíci
How to Perform Linear Regression using Excel
Easy Way to Stack up Data Vertically in Google Sheets
zhlédnutí 77Před 2 měsíci
Easy Way to Stack up Data Vertically in Google Sheets
How to Use the FILTER function in Google Sheets
zhlédnutí 240Před 2 měsíci
How to Use the FILTER function in Google Sheets
How to Import Data in Google Sheets using IMPORTRANGE
zhlédnutí 143Před 2 měsíci
How to Import Data in Google Sheets using IMPORTRANGE
How to Find Unique Values in Google Sheets
zhlédnutí 150Před 3 měsíci
How to Find Unique Values in Google Sheets
Do more videos about pands and numpy please
yes, many more coming 🙏
Can i have the links for the 3rd party straps?
Sure! here you go! Brown Leather Strap (20mm): amzn.to/3WDgRuZ Black Rubber Strap (20mm): amzn.to/3SKZVBk Pine/Olive Green Magnetic Sport Band (20mm): amzn.to/3X01m1q Pine/Olive Green Buckle Sport Band (20mm): amzn.to/3M2KalS
df = df.drop_duplicates() df = df.dropna() Using my jupyter notebook, I need to apply this to implement duplicate and dropna back to the df. If not the duplicates and dropna doesn't apply to the df.
yes that's correct! sorry that wasn't made as clear in the video
Where is the source of the data?
It's a dataset from USDA (United States Department of Agriculture)
Thank
Thank you
How do you make 52 wk High and low show a color when it goes over or under it
Flatten = unpivot?
@@CaribouDataScience yes! "unpivoting" is definitely one of the key use cases of the function
nice.. i like the presentation
@@mbilly3013 glad you found it helpful!