Skip to content
Avio Lines
Q9

String Functions

21 stations · 2.7h

CONCAT, SUBSTRING, string aggregation and regular expressions. 21 interview problems explained by Everyday Data Science (2.7h of video).

Start this line →
  1. Group Sold Products By The DateLC 1484 · 6:31
    EasyGoogle · Amazon · +1 more companiesLeetCode ↗ (opens in a new tab)
  2. Invalid TweetsLC 1683 · 3:40
    EasyGoogle · Amazon · +5 more companiesLeetCode ↗ (opens in a new tab)
  3. Fix Names in a TableLC 1667 · 6:28
    EasyGoogle · Amazon · +3 more companiesLeetCode ↗ (opens in a new tab)
  4. Fix Product Name FormatLC 1543 · 7:26 · LeetCode Premium
    EasyLeetCode ↗ (opens in a new tab)
  5. Find Users With Valid E-MailsLC 1517 · 8:12
    EasyGoogle · Amazon · +2 more companiesLeetCode ↗ (opens in a new tab)
  6. Patients With a ConditionLC 1527 · 4:29
    EasyGoogle · Amazon · +2 more companiesLeetCode ↗ (opens in a new tab)
  7. Finding the Topic of Each PostLC 2199 · 17:43 · LeetCode Premium
    HardMetaLeetCode ↗ (opens in a new tab)
  8. Invalid Tweets IILC 3150 · 4:48 · LeetCode Premium
    EasyLeetCode ↗ (opens in a new tab)
  9. Pizza Toppings Cost AnalysisLC 3050 · 6:09 · LeetCode Premium
    MediumAmazonLeetCode ↗ (opens in a new tab)
  10. Concatenate the Name and the ProfessionLC 2504 · 3:15 · LeetCode Premium
    EasyLeetCode ↗ (opens in a new tab)
  11. Find Trending HashtagsLC 3087 · 9:47 · LeetCode Premium
    MediumLeetCode ↗ (opens in a new tab)
  12. Find Cities in Each StateLC 3198 · 4:15 · LeetCode Premium
    EasyLeetCode ↗ (opens in a new tab)
  13. Top Three WineriesLC 2991 · 12:25 · LeetCode Premium
    HardGoogleLeetCode ↗ (opens in a new tab)
  14. Build the EquationLC 2118 · 8:59 · LeetCode Premium
    HardLeetCode ↗ (opens in a new tab)
  15. Find Cities in Each State IILC 3328 · 7:58 · LeetCode Premium
    MediumLeetCode ↗ (opens in a new tab)
  16. Find Valid EmailsLC 3436 · 5:56
    EasyLeetCode ↗ (opens in a new tab)
  17. Find Products with Three Consecutive DigitsLC 3415 · 5:25 · LeetCode Premium
    EasyLeetCode ↗ (opens in a new tab)
  18. DNA Pattern RecognitionLC 3475 · 6:21
    MediumGoogleLeetCode ↗ (opens in a new tab)
  19. Find Products with Valid Serial NumbersLC 3465 · 8:10
    EasyLeetCode ↗ (opens in a new tab)
  20. Find All Unique Email DomainsLC 3059 · 7:39 · LeetCode Premium
    EasyLeetCode ↗ (opens in a new tab)
  21. Find Invalid IP AddressesLC 3451 · 13:49
    HardLeetCode ↗ (opens in a new tab)

All 21 stations in order

  1. 1.Group Sold Products By The Date (LeetCode 1484)
  2. 2.Invalid Tweets (LeetCode 1683)
  3. 3.Fix Names in a Table (LeetCode 1667)
  4. 4.Fix Product Name Format (LeetCode 1543)
  5. 5.Find Users With Valid E-Mails (LeetCode 1517)
  6. 6.Patients With a Condition (LeetCode 1527)
  7. 7.Finding the Topic of Each Post (LeetCode 2199)
  8. 8.Invalid Tweets II (LeetCode 3150)
  9. 9.Pizza Toppings Cost Analysis (LeetCode 3050)
  10. 10.Concatenate the Name and the Profession (LeetCode 2504)
  11. 11.Find Trending Hashtags (LeetCode 3087)
  12. 12.Find Cities in Each State (LeetCode 3198)
  13. 13.Top Three Wineries (LeetCode 2991)
  14. 14.Build the Equation (LeetCode 2118)
  15. 15.Find Cities in Each State II (LeetCode 3328)
  16. 16.Find Valid Emails (LeetCode 3436)
  17. 17.Find Products with Three Consecutive Digits (LeetCode 3415)
  18. 18.DNA Pattern Recognition (LeetCode 3475)
  19. 19.Find Products with Valid Serial Numbers (LeetCode 3465)
  20. 20.Find All Unique Email Domains (LeetCode 3059)
  21. 21.Find Invalid IP Addresses (LeetCode 3451)