- Видео 34
- Просмотров 21 741
Median Pulse
Добавлен 12 май 2024
Welcome to Median Pulse!
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.
Просмотров: 48
Видео
Sales Dashboard in Looker Studio: Hands-On Tutorial
Просмотров 31914 дней назад
In this video, I show you how to build a simple sales dashboard from scratch in Looker Studio, step-by-step. Looker Studio Sales Dashboard: lookerstudio.google.com/s/lL-e9kuM4yI Dummy Sales Data: docs.google.com/spreadsheets/d/1QJfZtrQpowc7Kj1uRZRGr9Rf98WcE-YmFn5VX4bXI8I/edit?usp=sharing Get Started with Looker Studio: lookerstudio.google.com/ #dashboard #lookerstudio #tutorial #stepbystep
Animated Bar Chart in Python
Просмотров 23428 дней назад
In this video, I demonstrate how to create an animated bar chart using the plotly.express library in Python. #animated #bar #chart #plotly #python #datavisualization
Creating a Loan Amortization Table in Python
Просмотров 1432 месяца назад
In this video, I demonstrate how you can easily generate a loan amortization table using a simple Python script.
Removing Outliers in Python Using IQR Method
Просмотров 862 месяца назад
In this Python tutorial, I show you how to handle outliers and remove them using the IQR method.
Group Google Sheet Pivot Table Rows into Ranges
Просмотров 3002 месяца назад
In this video, I demonstrate how to group data into bin ranges in Google Sheet pivot tables.
Group Data into Bin Ranges in Excel Pivot Tables
Просмотров 3602 месяца назад
In this video, I show how to group data into bin ranges in Excel pivot tables using an easy-to-follow example.
AI-Powered Data Visualization in Python with Google Colab
Просмотров 1313 месяца назад
In this video, we'll learn how to create instant data visualizations in Python using Google Colab. #python #googlecolab #seaborn #datavisualization #ai
Withings ScanWatch Nova Review: Hybrid Watch for Health Data Tracking
Просмотров 14 тыс.3 месяца назад
My thoughts and impressions on the Withings ScanWatch Nova Hybrid Smartwatch! Withings ScanWatch Nova on Amazon (US): amzn.to/4f2q7kf Withings ScanWatch Nova on Amazon (UK): amzn.to/3UzEmon 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 (Links a...
Linear Programming in Python with SciPy - Easy Example!
Просмотров 1363 месяца назад
In this video, I demonstrate how to use the SciPy library in Python to solve linear programming problems.
Data Cleaning 101 in Python
Просмотров 9203 месяца назад
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
Просмотров 713 месяца назад
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)
Просмотров 2224 месяца назад
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
Просмотров 3284 месяца назад
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!
Просмотров 474 месяца назад
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: ruclips.net/video/5VoqTOXX5OU/видео.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
Просмотров 3914 месяца назад
Import Data from Google Drive to Google Sheets Using Appscript
Build a Live S&P 500 Stock Watchlist in Google Sheets
Просмотров 1,3 тыс.4 месяца назад
Build a Live S&P 500 Stock Watchlist in Google Sheets
2D Lookup on Matrix Data Using INDEX-MATCH in Google Sheets/MS Excel
Просмотров 2555 месяцев назад
2D Lookup on Matrix Data Using INDEX-MATCH in Google Sheets/MS Excel
Email Google Sheets Data as CSV Using Appscript Automatically
Просмотров 625 месяцев назад
Email Google Sheets Data as CSV Using Appscript Automatically
Calculated Field in Google Sheets Pivot Tables - Explained!
Просмотров 2605 месяцев назад
Calculated Field in Google Sheets Pivot Tables - Explained!
How to Calculate Weighted Average in Google Sheets
Просмотров 3875 месяцев назад
How to Calculate Weighted Average in Google Sheets
How to Create Summary Statistics in Google Sheets
Просмотров 1015 месяцев назад
How to Create Summary Statistics in Google Sheets
Bulk Translate Data using GOOGLETRANSLATE() in Google Sheets
Просмотров 1565 месяцев назад
Bulk Translate Data using GOOGLETRANSLATE() in Google Sheets
Two Ways to Remove Gridlines in Google Sheets
Просмотров 1465 месяцев назад
Two Ways to Remove Gridlines in Google Sheets
How to Merge CSV Files Using Pandas in Python
Просмотров 705 месяцев назад
How to Merge CSV Files Using Pandas in Python
Import HTML web tables into Google Sheets using IMPORTHTML()
Просмотров 1905 месяцев назад
Import HTML web tables into Google Sheets using IMPORTHTML()
Insert Images Dynamically in Google Sheets Using IMAGE() function
Просмотров 3975 месяцев назад
Insert Images Dynamically in Google Sheets Using IMAGE() function
Solving Linear Programming Problems With Excel Solver Add-in
Просмотров 1505 месяцев назад
Solving Linear Programming Problems With Excel Solver Add-in
Using the PROPER function to Clean up Text Capitalization in Google Sheets
Просмотров 1835 месяцев назад
Using the PROPER function to Clean up Text Capitalization in Google Sheets
How to Perform Linear Regression using Excel
Просмотров 815 месяцев назад
How to Perform Linear Regression using Excel
My HSA covers these, and my employer gives me 1k a year in HSA money. I’ll be buying this watch basically free of charge to me 😅 can’t wait.
thank you
Great review, although you didn't mention if it has a luminous dial. I have the original ScanWatch and it only has luminous hands, which I find is a bit vague at 2AM...
Great question, yeah I missed that out. It does have a luminous dial
Great review, thanks so much. I only found out about this watch today.
Awesome review! How has it been for reliability? I've had Withings watches going back to the Activite, but I've heard a few warnings about customer service and reliability since the Nokia takeover. Them switching from a 5 year warranty down to a 2 year warranty worries me too...
It's built really well - only had it for a year and still good as new. I wear it everyday too
My Steel HR, ScanWatch 1 and 2 all work no issues if it helps. Bought them all at their respective launches.
Hey! Pl make more video on optimization
For sure, anything specific you wanted to learn?
@@MedianPulse sensitivity analysis
I use one since a few years. And now the battery lost a lot of capacity. And guess what, it can NOT be replaced! Withings does not even offer a replacement service. This is really annoying, because the watch actually is very good and the battery used to last for four weeks. Now mine is down to one week only.
IT sad, that we cant replace battery, but what can do someone who has "traditional" smartwatch and must charge almost everyday. Week of working is a dream for this devices.
Wonderful! Thanks, how could we insert this animation into Powerpoint?
Great review.
Is it just me or are the bezels misaligned ?
They are at the time of the video but easily rotateable
I am scared of buying this Watch Because of their subscription. Do you feel like their Withings + is mandatory?
I wouldn't worry about that, personally I don't use the subscription as it doesn't offer anything I need and that's not already offered free out of the box
Pro tip with third party bands (for any smart watch) activity tracker. Get yourself some third party nylon bands, far more comfortable for sleeping in.
Hi! Can I control music from my iPhone using this watch???
I have not owned a smartwatch before so I have no idea 😅
Hey, I don't believe this is possible with the Withings watch
No that’s not a function of any Withings watches.
Thanks, this was much useful. Please make more videos on using google sheets for investing and trading
I'm the same way as far as charging. They give you sleep tracking, but it has to be charging all night. I switched to Gshock, and then to the Garmin Instinct. Best watch I have owned. I found that I didn't use most of the shit that you would use an Apple Watch or Galaxy Watch.
if possible plz make more video related to this
Great video !!
At 9:49, when you mentioned the price, the little activity tracker man went bolting! 😂 Outstanding review. Thanks for taking the time and sharing. Most probably would go for the black, although that blue has a mysterious allure to it...
That's funny lol. Sure thing, glad you found it helpful. The color choice was definitely a tough one for me too cause they all look really good!
@@MedianPulse I went blue. More versatile than green and black is too corporate for my personal taste. I had a blue Horizon (predecessor) too.
@@angusgibbins4954 a photo of the blue would be awesome if you have one, I’m leaning towards the blue
Nice review! Can the time on the OLED display be changed from 24 hour military format to 12 hour format?
yes of course
Thanks for the google spread sheet.
Ceramic bezel also wow!
Will it work with a Chinese rom phone like the oppo find ne fold
@@simongorton3229 it should work, you'll just need to download the Withings app
Thanks for the review
The dial isnt aligned properly... yikes!
The bezel rotates
@@Baba-sz9jb yes but even if it rotates. does it centerizze? i heard of complains
@@bledig I assume it does, but I don't know
I can confirm it does rotate and align perfectly. Prior to the video I was playing around and rotating it, which is why it wasn't perfectly aligned. Hope that's reassuring! :)
Glad to see a review for the Nova... as you say, there aren't many reviews out there. 🙏
I want try to try this out. Would you recommend the nova or SCANWATCH 2?
I personally like the Nova for its design, but if you prefer something more minimalistic (and affordable) the Scanwatch 2 is great!
Thank you
Great review, one of the best for the product!, not many reviews as you stated, but i think you covered it well.
Thank you so much! glad you found it helpful
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!