Sign in

Joram Mutenge

@jorammutenge.com
71 followers 19 following 479 posts

My data consulting company www.conterval.com

PostsRepliesMedia
Joram Mutenge @jorammutenge.com · 08/07/2026
So 2 months ago, I gave a talk at #PyConUS on how to write idiomatic Polars code. Here's the full video. www.youtube.com/watch?v=5-4x...
youtube.com
Don’t Write Polars Code with a Pandas Accent - Joram Montege
YouTube video by PyCon US
011
Joram Mutenge @jorammutenge.com · 04/07/2026
Most people think of Excel when they hear pivot tables. You can create advanced pivot tables with @pola.rs Full article www.conterval.com/blog/advance...
000
Joram Mutenge @jorammutenge.com · 23/06/2026
When I'm analyzing data, I always use the best tool as long as that tool is @pola.rs Learn how to use it and you'll know what I mean. Amazon (Kindle or Paperback) www.amazon.com/dp/B0GXG1BHG6/ Leanpub (eBook or PDF) leanpub.com/deep-analysi...
000
Joram Mutenge @jorammutenge.com · 04/06/2026
Full essay www.jorammutenge.com/posts/daisy-...
000
Joram Mutenge @jorammutenge.com · 17/05/2026
#PyConUS talk at Long Beach, CA went superbly. Many people came to me with questions in the hallway, some of which I didn't have the answers to. All the more reason to dig deeper into @pola.rs
030
Joram Mutenge @jorammutenge.com · 28/04/2026
I'll be speaking at PyCon. Attend my talk to learn idiomatic ways of using @pola.rs for data analysis.
010
Joram Mutenge @jorammutenge.com · 18/04/2026
My @pola.rs book is out and ready for purchase. #dataanalysis #datascience Amazon (Kindle and Paperback) www.amazon.com/dp/B0GXG1BHG6/ Leanpub (eBook and PDF) leanpub.com/deep-analysi...
020
Joram Mutenge @jorammutenge.com · 15/04/2026
Criticizing is cheap and easy. Creating is hard.
000
Joram Mutenge @jorammutenge.com · 07/02/2026
Data scientists won't be doing text analysis on Enron emails anymore. There's a new dataset in town: the Epstein emails.
010
Joram Mutenge @jorammutenge.com · 22/01/2026
First draft of my @pola.rs book is out. I want feedback from readers to make it better. You can read for free here #Data #Analysis www.conterval.com/polars-book/
011
Joram Mutenge @jorammutenge.com · 07/01/2026
Just heard on the news that: An average American consumes more energy in a month than an average Indian consumes in a year. Now that's staggering!
000
Joram Mutenge @jorammutenge.com · 01/01/2026
Yes, I track every movie/series I watch. Here's some analysis www.conterval.com/blog/movies-...
000
Joram Mutenge @jorammutenge.com · 27/11/2025
110
Joram Mutenge @jorammutenge.com · 22/11/2025
I'm writing a @pola.rs book. (This post will remind me that I need to finish it. STAMPED FOR HISTORY)
020
Joram Mutenge @jorammutenge.com · 22/11/2025
One emoji can contain many bytes 🤯 Full article www.conterval.com/blog/bytes-i...
000
Joram Mutenge @jorammutenge.com · 16/08/2025
Blogging is like a cheatsheet for your mind. Whenever you have a conversation with someone on a topic you've written about, you are guaranteed of offering an intelligent contribution.
000
Joram Mutenge @jorammutenge.com · 30/07/2025
Data analysis is just rearranging numbers, if you distill it to its core.
000
Joram Mutenge @jorammutenge.com · 17/07/2025
Full article www.conterval.com/blog/copy-pa... Enough said.
000
Joram Mutenge @jorammutenge.com · 15/07/2025
The masterpiece is finally published! One reader said I invented a who new book genre: "narrativized data analysis" Click "Read sample" and read a few pages here www.amazon.com/dp/B0FHFWZFT9/
amazon.com
EMAILS FROM A BIG DATA ENTREPRENEUR TO HIS SON
EMAILS FROM A BIG DATA ENTREPRENEUR TO HIS SON: 9798292273066: Computer Science Books @ Amazon.com
000
Joram Mutenge @jorammutenge.com · 15/07/2025
Filtering for multiple items is easy in @pola.rs Full article www.conterval.com/blog/filter-...
010
Joram Mutenge @jorammutenge.com · 12/07/2025
Yes, aggregations can also be done on text data in @pola.rs www.conterval.com/blog/aggrega...
000
Joram Mutenge @jorammutenge.com · 07/07/2025
"History is too often not what happened, but what was recorded. A lie set down on paper with wet ink becomes a truth when dry."
000
Joram Mutenge @jorammutenge.com · 05/07/2025
So you want to learn how to #code? Full article: www.conterval.com/blog/
000
Joram Mutenge @jorammutenge.com · 30/06/2025
Dates are weired. E.g American dates begin with month. @pola.rs makes it easy to change the way your dates look, depending on the audience. Here's short and long text date formats. You can do more! This is the final #100DaysOfPolars post. Find all the posts here www.conterval.com/blog/#catego...
010
Joram Mutenge @jorammutenge.com · 29/06/2025
JSON data can be nested on multiple levels. But @pola.rs has a way to convert it to tabular format based on the level of your choosing. Best for dealing with API data or web requests in JSON. Even more ways to use Polars in the course www.udemy.com/course/analy... #100DaysOfPolars #data
241
Joram Mutenge @jorammutenge.com · 28/06/2025
You have a table of passwords and (for whatever reason) you want to count the number of digits in each password. Here's how to do it with @pola.rs Even more ways to use Polars in the course www.udemy.com/course/analy... #100DaysOfPolars #datasky
010
Joram Mutenge @jorammutenge.com · 27/06/2025
He is a nice trick to demonstrate how versatile @pola.rs is. I have parts of a phone number and want to join them into a complete phone number. More tricks in the Polars course www.udemy.com/course/analy... #100DaysOfPolars #datasky
010
Joram Mutenge @jorammutenge.com · 26/06/2025
What if you wanted to round time the way round decimal numbers? Well, sort of Here, I use @pola.rs to scan a 10 minute interval and make the value in between same as the lower bound. So minutes between 0 and 10 become 0, minutes between 10 and 20 become 10 etc. #100DaysOfPolars #datasky
010
Joram Mutenge @jorammutenge.com · 26/06/2025
Maybe they're keeping it a secret. Full article: www.conterval.com/blog/ibis-fo... @voltrondata.bsky.social
000
Joram Mutenge @jorammutenge.com · 25/06/2025
In @pola.rs, it's very easy to make the first letter of each word a capital letter. Here, I properly punctuate the book titles of some of my favorite authors. #100DaysOfPolars #datasky
010
Joram Mutenge @jorammutenge.com · 24/06/2025
Full article: www.conterval.com/blog/convert... #python
000
Joram Mutenge @jorammutenge.com · 24/06/2025
When you have timeseries data, @pola.rs has a special type of grouping that lets you be a lot more granular in your grouping. Here, we see the total power usage every 5 hours and 30 minutes. Now that's granular! #100DaysOfPolars #datasky
010
Joram Mutenge @jorammutenge.com · 24/06/2025
Full article www.conterval.com/blog/add-cur... #datasky
010
Joram Mutenge @jorammutenge.com · 23/06/2025
When you change the timezone on your date column, the time also changes. What if you want to change the timezone but maintain the time? Here's how to do it in @pola.rs #100DaysOfPolars #data
010
Joram Mutenge @jorammutenge.com · 22/06/2025
Data analysis involves neglecting certain rows and focusing on specific rows of data. Here we use @pola.rs to neglect all rows and focus on one row with the maximum grade. Even more ways to use Polars in this course www.udemy.com/course/analy... #100DaysOfPolars #datasky
010
Joram Mutenge @jorammutenge.com · 21/06/2025
You have a large Parquet dataset. You want to find out what columns it has and the data types of those columns—without reading the entire dataset. @pola.rs can help you do just that! Even more way to use Polars in this course www.udemy.com/course/analy... #100DaysOfPolars #datasky
020
Joram Mutenge @jorammutenge.com · 20/06/2025
Full article: www.conterval.com/blog/removin... #datasky
010
Joram Mutenge @jorammutenge.com · 20/06/2025
You are querying a historical database with dates, and you want to create another column of centuries for those dates. @pola.rs makes it super easy to do this. Look there's a Polars course www.udemy.com/course/analy... #100DaysOfPolars #datasky
020
Joram Mutenge @jorammutenge.com · 20/06/2025
Full article: www.conterval.com/blog/polars-... #dataanalysis
120
Joram Mutenge @jorammutenge.com · 19/06/2025
Sometimes you may have a column identified as a string when it's supposed to be a decimal. Here, I use @pola.rs to convert the data type to decimal. This is different from float type. You can see in the type that the max number of digits after the decimal point is 2. #100DaysOfPolars #datasky
020
Joram Mutenge @jorammutenge.com · 18/06/2025
Most people read CSV files and then change the data type of columns. That's an amateur way. The pro way is to do it all at once. Here, I use @pola.rs to change the data type of Day_Count from number to text. Learn more in the Polars course www.udemy.com/course/analy... #100DaysOfPolars #datasky
040
Joram Mutenge @jorammutenge.com · 17/06/2025
Counting the number of days between dates is super easy in @pola.rs Learn more in the Polars course www.udemy.com/course/analy... #100DaysOfPolars #datasky
010
Joram Mutenge @jorammutenge.com · 16/06/2025
The number of characters in text is not always the same as the number of bytes. Especially when the text contains emojis. @pola.rs helps us here to count characters and bytes in text. #100DaysOfPolars #datasky
010
Joram Mutenge @jorammutenge.com · 15/06/2025
You have part numbers for your products, but you want to make sure that they all have 6 characters to maintain same length. Here, we use @pola.rs to add zeros at the end of product numbers with less than 6 characters. #100DaysOfPolars #datasky
010
Joram Mutenge @jorammutenge.com · 14/06/2025
You have data in table 2 and table 2. But you want to find values that are in table 1 and not in table 2. Here, we use @pola.rs to get names of students who failed the exam from the list of all students. If you're into math, this is the same as set difference. #100DaysOfPolars #datasky
010
Joram Mutenge @jorammutenge.com · 13/06/2025
You have a table with repeating names and want to get the index where each unique name appear. Here, we use @pola.rs to get the first appearance of each name. #100DaysOfPolars #datasky
010
Joram Mutenge @jorammutenge.com · 12/06/2025
Full article: www.conterval.com/blog/your-be...
000
Joram Mutenge @jorammutenge.com · 12/06/2025
Most people read a CSV file with bad column names, and then rename those bad column names. Stop doing that. Here, we use @pola.rs to read a CSV file by specifying what we want to call the columns. #100DaysOfPolars #datasky
010
Joram Mutenge @jorammutenge.com · 11/06/2025
With @pola.rs you can convert dates to timestamp in milliseconds. Here, we show the milliseconds that passed since 1 Jan 1970 when Unix time counting starts. #100DaysOfPolars #datasky
010
Joram Mutenge @jorammutenge.com · 10/06/2025
@pola.rs has has a special data type that allows you to filter text values based on hierarchy. Here we get people who have a master's degree or higher. #100DaysOfPolars #datasky
110