Welcome to part 5 of Fun with Pandas featuring our founders 👌
.
Fast and robust string operations are crucial to a large data framework. As shown, one can split columns based on unique patterns of their values .
Here, the separation of city from state/province and country is possible through finding the common pattern of “, “ between city and state and between state and country
.
At the end, we are curious to know more about our South African born founder so we filter on South Africa 🇿🇦 .
No hard feelings Bill, Mark, and Jeff. We are curious about you too 😍

.

👨‍💻#Pandas

Today, we are gonna talk about:
.
assign()
.
assign() lets do create a new column from a different column with some modification 💪
.
Here we are subtracting our founders’ birth year from the current year to find their ages +/- 1 year 👍
.
Later, we use the mean() function we covered in Part 3 of these series to find that together our favorite founders are 51.5 years young ‼️


.

👨‍💻#Pandas