Joram Mutenge

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

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

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

Full essay www.jorammutenge.com/posts/daisy-...

#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

I'll be speaking at PyCon. Attend my talk to learn idiomatic ways of using @pola.rs for data analysis.

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

Criticizing is cheap and easy. Creating is hard.

Data scientists won't be doing text analysis on Enron emails anymore. There's a new dataset in town: the Epstein emails.

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/

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!

Yes, I track every movie/series I watch. Here's some analysis www.conterval.com/blog/movies-...

I'm writing a @pola.rs book. (This post will remind me that I need to finish it. STAMPED FOR HISTORY)

One emoji can contain many bytes 🤯 Full article www.conterval.com/blog/bytes-i...

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.

Data analysis is just rearranging numbers, if you distill it to its core.

Full article www.conterval.com/blog/copy-pa... Enough said.

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/

Filtering for multiple items is easy in @pola.rs Full article www.conterval.com/blog/filter-...

Yes, aggregations can also be done on text data in @pola.rs www.conterval.com/blog/aggrega...

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

So you want to learn how to #code? Full article: www.conterval.com/blog/

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

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

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

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

Maybe they're keeping it a secret. Full article: www.conterval.com/blog/ibis-fo... @voltrondata.bsky.social

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

Full article: www.conterval.com/blog/convert... #python

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

Full article www.conterval.com/blog/add-cur... #datasky

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

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

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

Full article: www.conterval.com/blog/removin... #datasky

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

Full article: www.conterval.com/blog/polars-... #dataanalysis

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

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

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

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

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

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

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

Full article: www.conterval.com/blog/your-be...

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

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