Median Pulse
Median Pulse
  • 32
  • 9 382
Creating a Loan Amortization Table in Python
In this video, I demonstrate how you can easily generate a loan amortization table using a simple Python script.
Переглядів: 30

Відео

Removing Outliers in Python Using IQR Method10:09Removing Outliers in Python Using IQR Method
Removing Outliers in Python Using IQR Method
Переглядів 39День тому
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 Ranges1:45Group Google Sheet Pivot Table Rows into Ranges
Group Google Sheet Pivot Table Rows into Ranges
Переглядів 82День тому
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 Tables3:36Group Data into Bin Ranges in Excel Pivot Tables
Group Data into Bin Ranges in Excel Pivot Tables
Переглядів 24914 днів тому
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 Colab2:37AI-Powered Data Visualization in Python with Google Colab
AI-Powered Data Visualization in Python with Google Colab
Переглядів 8821 день тому
In this video, we'll learn how to create instant data visualizations in Python using Google Colab. #python #googlecolab #seaborn #datavisualization #ai
How to "VLOOKUP" in Python using Pandas?4:17How to "VLOOKUP" in Python using Pandas?
How to "VLOOKUP" in Python using Pandas?
Переглядів 59Місяць тому
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.
Withings ScanWatch Nova Review: Hybrid Watch for Health Data Tracking10:42Withings ScanWatch Nova Review: Hybrid Watch for Health Data Tracking
Withings ScanWatch Nova Review: Hybrid Watch for Health Data Tracking
Переглядів 4,7 тис.Місяць тому
My thoughts and impressions on the Withings ScanWatch Nova Hybrid Smartwatch! 🛒 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 20mm: amzn.to/3M2KalS (Links above ...
Linear Programming in Python with SciPy - Easy Example!6:04Linear Programming in Python with SciPy - Easy Example!
Linear Programming in Python with SciPy - Easy Example!
Переглядів 87Місяць тому
In this video, I demonstrate how to use the SciPy library in Python to solve linear programming problems.
Data Cleaning 101 in Python13:01Data Cleaning 101 in Python
Data Cleaning 101 in Python
Переглядів 874Місяць тому
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 Instead3:50Stop Doing Nested Ifs Like This - Use IFS Instead
Stop Doing Nested Ifs Like This - Use IFS Instead
Переглядів 60Місяць тому
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)4:41FLATTEN in Google Sheets: Combine Multiple Columns into One (3 Examples)
FLATTEN in Google Sheets: Combine Multiple Columns into One (3 Examples)
Переглядів 1802 місяці тому
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 Tips8:54Certified Analytics Professional (CAP) Certification Guide and Preparation Tips
Certified Analytics Professional (CAP) Certification Guide and Preparation Tips
Переглядів 1502 місяці тому
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!1:49Publish Google Sheets as Web Page - Fast & Easy!
Publish Google Sheets as Web Page - Fast & Easy!
Переглядів 402 місяці тому
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: ua-cam.com/video/5VoqTOXX5OU/v-deo.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 Appscript8:15Import Data from Google Drive to Google Sheets Using Appscript
Import Data from Google Drive to Google Sheets Using Appscript
Переглядів 1502 місяці тому
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 Sheets23:35Build a Live S&P 500 Stock Watchlist in Google Sheets
Build a Live S&P 500 Stock Watchlist in Google Sheets
Переглядів 3462 місяці тому
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 Excel4:172D Lookup on Matrix Data Using INDEX-MATCH in Google Sheets/MS Excel
2D Lookup on Matrix Data Using INDEX-MATCH in Google Sheets/MS Excel
Переглядів 1762 місяці тому
2D Lookup on Matrix Data Using INDEX-MATCH in Google Sheets/MS Excel
Email Google Sheets Data as CSV Using Appscript Automatically6:27Email Google Sheets Data as CSV Using Appscript Automatically
Email Google Sheets Data as CSV Using Appscript Automatically
Переглядів 532 місяці тому
Email Google Sheets Data as CSV Using Appscript Automatically
Calculated Field in Google Sheets Pivot Tables - Explained!4:45Calculated Field in Google Sheets Pivot Tables - Explained!
Calculated Field in Google Sheets Pivot Tables - Explained!
Переглядів 2412 місяці тому
Calculated Field in Google Sheets Pivot Tables - Explained!
How to Calculate Weighted Average in Google Sheets3:04How to Calculate Weighted Average in Google Sheets
How to Calculate Weighted Average in Google Sheets
Переглядів 1242 місяці тому
How to Calculate Weighted Average in Google Sheets
How to Create Summary Statistics in Google Sheets2:44How to Create Summary Statistics in Google Sheets
How to Create Summary Statistics in Google Sheets
Переглядів 792 місяці тому
How to Create Summary Statistics in Google Sheets
Bulk Translate Data using GOOGLETRANSLATE() in Google Sheets2:18Bulk Translate Data using GOOGLETRANSLATE() in Google Sheets
Bulk Translate Data using GOOGLETRANSLATE() in Google Sheets
Переглядів 1272 місяці тому
Bulk Translate Data using GOOGLETRANSLATE() in Google Sheets
Two Ways to Remove Gridlines in Google Sheets2:15Two Ways to Remove Gridlines in Google Sheets
Two Ways to Remove Gridlines in Google Sheets
Переглядів 1342 місяці тому
Two Ways to Remove Gridlines in Google Sheets
How to Merge CSV Files Using Pandas in Python4:02How to Merge CSV Files Using Pandas in Python
How to Merge CSV Files Using Pandas in Python
Переглядів 632 місяці тому
How to Merge CSV Files Using Pandas in Python
Import HTML web tables into Google Sheets using IMPORTHTML()3:02Import HTML web tables into Google Sheets using IMPORTHTML()
Import HTML web tables into Google Sheets using IMPORTHTML()
Переглядів 982 місяці тому
Import HTML web tables into Google Sheets using IMPORTHTML()
Insert Images Dynamically in Google Sheets Using IMAGE() function1:08Insert Images Dynamically in Google Sheets Using IMAGE() function
Insert Images Dynamically in Google Sheets Using IMAGE() function
Переглядів 2372 місяці тому
Insert Images Dynamically in Google Sheets Using IMAGE() function
Solving Linear Programming Problems With Excel Solver Add-in9:49Solving Linear Programming Problems With Excel Solver Add-in
Solving Linear Programming Problems With Excel Solver Add-in
Переглядів 1162 місяці тому
Solving Linear Programming Problems With Excel Solver Add-in
Using the PROPER function to Clean up Text Capitalization in Google Sheets0:58Using the PROPER function to Clean up Text Capitalization in Google Sheets
Using the PROPER function to Clean up Text Capitalization in Google Sheets
Переглядів 1753 місяці тому
Using the PROPER function to Clean up Text Capitalization in Google Sheets
How to Perform Linear Regression using Excel6:51How to Perform Linear Regression using Excel
How to Perform Linear Regression using Excel
Переглядів 813 місяці тому
How to Perform Linear Regression using Excel
Easy Way to Stack up Data Vertically in Google Sheets3:16Easy Way to Stack up Data Vertically in Google Sheets
Easy Way to Stack up Data Vertically in Google Sheets
Переглядів 783 місяці тому
Easy Way to Stack up Data Vertically in Google Sheets
How to Use the FILTER function in Google Sheets2:29How to Use the FILTER function in Google Sheets
How to Use the FILTER function in Google Sheets
Переглядів 2473 місяці тому
How to Use the FILTER function in Google Sheets

КОМЕНТАРІ

  • @airmanfirstclass3535
    @airmanfirstclass3535 4 дні тому

    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...

    • @MedianPulse
      @MedianPulse 4 дні тому

      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!

  • @GeoTheBlaxican
    @GeoTheBlaxican 6 днів тому

    Nice review! Can the time on the OLED display be changed from 24 hour military format to 12 hour format?

  • @sureshkumar-gy1ye
    @sureshkumar-gy1ye 9 днів тому

    Thanks for the google spread sheet.

  • @iandegroeve8198
    @iandegroeve8198 12 днів тому

    Ceramic bezel also wow!

  • @simongorton3229
    @simongorton3229 12 днів тому

    Will it work with a Chinese rom phone like the oppo find ne fold

    • @MedianPulse
      @MedianPulse 12 днів тому

      @@simongorton3229 it should work, you'll just need to download the Withings app

  • @robinjhunter
    @robinjhunter 15 днів тому

    Thanks for the review

  • @thbpe86
    @thbpe86 19 днів тому

    The dial isnt aligned properly... yikes!

    • @Baba-sz9jb
      @Baba-sz9jb 16 днів тому

      The bezel rotates

    • @bledig
      @bledig 16 днів тому

      @@Baba-sz9jb yes but even if it rotates. does it centerizze? i heard of complains

    • @Baba-sz9jb
      @Baba-sz9jb 15 днів тому

      @@bledig I assume it does, but I don't know

    • @MedianPulse
      @MedianPulse 15 днів тому

      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! :)

    • @philauguste7310
      @philauguste7310 13 днів тому

      Glad to see a review for the Nova... as you say, there aren't many reviews out there. 🙏

  • @MrRey84972
    @MrRey84972 23 дні тому

    I want try to try this out. Would you recommend the nova or SCANWATCH 2?

    • @MedianPulse
      @MedianPulse 22 дні тому

      I personally like the Nova for its design, but if you prefer something more minimalistic (and affordable) the Scanwatch 2 is great!

  • @fayozsaidov9868
    @fayozsaidov9868 24 дні тому

    Thank you

  • @marklacroix8639
    @marklacroix8639 25 днів тому

    Great review, one of the best for the product!, not many reviews as you stated, but i think you covered it well.

    • @MedianPulse
      @MedianPulse 24 дні тому

      Thank you so much! glad you found it helpful

  • @pavanKumar-lh3hb
    @pavanKumar-lh3hb Місяць тому

    Do more videos about pands and numpy please

    • @MedianPulse
      @MedianPulse Місяць тому

      yes, many more coming 🙏

  • @winsentize
    @winsentize Місяць тому

    Can i have the links for the 3rd party straps?

    • @MedianPulse
      @MedianPulse Місяць тому

      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

  • @uzairsukor9366
    @uzairsukor9366 Місяць тому

    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.

    • @MedianPulse
      @MedianPulse Місяць тому

      yes that's correct! sorry that wasn't made as clear in the video

  • @thiennguyen1721
    @thiennguyen1721 Місяць тому

    Where is the source of the data?

    • @MedianPulse
      @MedianPulse Місяць тому

      It's a dataset from USDA (United States Department of Agriculture)

  • @tanakornpromthep9025
    @tanakornpromthep9025 Місяць тому

    Thank

  • @tanakornpromthep9025
    @tanakornpromthep9025 Місяць тому

    Thank you

  • @contrarianthinker
    @contrarianthinker 2 місяці тому

    How do you make 52 wk High and low show a color when it goes over or under it

  • @CaribouDataScience
    @CaribouDataScience 2 місяці тому

    Flatten = unpivot?

    • @MedianPulse
      @MedianPulse 2 місяці тому

      @@CaribouDataScience yes! "unpivoting" is definitely one of the key use cases of the function

  • @mbilly3013
    @mbilly3013 2 місяці тому

    nice.. i like the presentation

    • @MedianPulse
      @MedianPulse 2 місяці тому

      @@mbilly3013 glad you found it helpful!