💰💰 Extracting price from invoices was never this easy: Regex Finale

Welcome back to Pandas Daily! Your daily 5-minute boost to becoming confident in Python.

I am sure you are excited for the weekend. So am I. Today is our last stop in regex!

You now know how to fetch phones, emails, names from any text. There is one more layer that makes regex powerful.

With that you can -

catch both color, colour
match Nov, November irrespective of how they are written
Extract both $ and 200 from a $200 invoice, and more..

🎁 Bonus at the end: A great resource with 30 regex problems you can try

⭐ (*) for zero or more

'u' is optional → for handling British vs American spellings

  In:

    import re

    text = "I like the color blue. She likes the colour red."

    print(re.findall(r"colou*r", text))

  Out:
  ['color', 'colour']

❓ for zero or max one

Good to handle abbreviations

  In:

    text = "Nov 11, November 11"

    # (?:ember)? → "ember" is optional

    print(re.findall(r"Nov(?:ember)?", text))

  Out:
  ['Nov', 'November']

👉👈 Control length (m,n)

If you are interested in error logs which are 2 or 3 digit

  In:

    text = "Error codes: 4, 23, 456, 7890"

    # \d{2,3} → match numbers 2–3 digits long

    print(re.findall(r"\b\d{2,3}\b", text))

  Out:
  ['23', '456']

🤝 Capture currency and amount separately with Groups ( )

  In:

    text = "Total: $250, Discount: €30"

    # (\$|€) → group 1: currency

    # (\d+) → group 2: number

    print(re.findall(r"(\$|€)(\d+)", text))

  Out:
  [('$', '250'), ('€', '30')]

↔️ Match either of them ( | )

Mention of cat or dog in reviews

  In:

    text = "The shelter has a cat and a dog."

    print(re.findall(r"cat|dog", text))

  Out:
  ['cat', 'dog']

🏃🏻‍♂️‍➡️ Check if a is followed by b using (?=..)

Find if they have apple juice in the menu

  In:

    text = "apple pie, apple juice, apple tart"

    # (?=\sjuice) → match 'apple' only if followed by 'juice'

    print(re.findall(r"apple(?=\sjuice)", text))

  Out:
  ['apple']

🎯 Finally!! We are now done with regex!! 🎁 Do checkout this bonus resource - 30 regex exercises with solutions.

⭐📣 That's it for today! If you liked it, please share it with anyone who will find it useful and share your feedback below 🐼

Your feedback helps us move in the right direction!

⭐⭐⭐ Great

⭐⭐ Decent

⭐ Needs improvement

Pandas Daily

💰💰 Extracting price from invoices was never this easy: Regex Finale

😰 We can't escape Python's escape sequences

📂 Stop downloading course lectures 1-by-1 — grab the whole playlist

🎯 Pick exact YouTube quality you want