Mito Tutorial Ep. 10 - Type Changes
Skills:
Data Literacy70%
Key Takeaways
Mito's type casting features and point-and-click type changes for data and formula columns in dataframes
Full Transcript
here i'll show you how you can change data types in place with mito the first thing to notice is that each column has a little icon that lets us know what the data type of that column is and to change the data type all i have to do is click this button here we'll see the data type this is an integer i can change this to a float there we go or i can change this back to an integer and for any column we can change to pool int float string date time or time delta you
Original Description
In this video, we have Jake (co-founder of Mito) to show us how to change the data type of data and formula columns using Mito's type casting features. Mito's point and click type changes make it easy to identify the data type of each column in your dataframe, and cast those columns to a different type.
🌟 Download Kite for FREE https://www.kite.com/get-kite/?utm_medium=referral&utm_source=youtube&utm_campaign=dataprofessor&utm_content=description-only
⭕ Step-by-step instructions
1. Identifying Data Types
For each column in your dataframe, the datatype is displayed in the column header. The icon will help you distinguish between int/floats, strings, booleans, and dates/time deltas.
2. Changing Data Types
There are two ways to change the data type of columns inside Mito.
Firstly, for data columns (any column that was not created by a Mito spreadsheet formula), you can use the column dtype select dropdown in the column control panel. Just select the dtype that you want to cast the column series to.
For formula columns, you can use the typecasting spreadsheet formulas. To do so, add the VALUE, TEXT BOOL, or DATEVALUE function to your formula to convert your column to a number, string, boolean, or datetime respectively.
Source: https://docs.trymito.io/how-to/type-changes
⭕ Support my work:
🌟 Subscribe to this channel (Coding Professor) https://www.youtube.com/channel/UCJzlfIoF8nmWqJIv_iWQVRw?sub_confirmation=1
🌟 Subscribe to my other channel Data Professor https://www.youtube.com/dataprofessor?sub_confirmation=1
🌟 Join the Newsletter of Data Professor http://newsletter.dataprofessor.org
🌟 Buy me a coffee https://www.buymeacoffee.com/dataprofessor
⭕ Recommended Books:
🌟https://kit.co/dataprofessor
✅ Python Basics: A Practical Introduction to Python 3 https://amzn.to/3awdWgm
✅ Learn Python Programming (The no-nonsense, beginner's guide) https://amzn.to/2RFpSpn
✅ Learn to Program with Minecraft https://amzn.to/3x2MujZ
✅ Automate the Boring Stuff with Pyt
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
More on: Data Literacy
View skill →
🎓
Tutor Explanation
DeepCamp AI