Create an account


Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Tut] Tilde Python Pandas DataFrame

#1
Tilde Python Pandas DataFrame

Python’s Tilde ~n operator is the bitwise negation operator: it takes the number n as binary number and “flips” all bits 0 to 1 and 1 to 0 to obtain the complement binary number. For example, the tilde operation ~1 becomes 0 and ~0 becomes 1 and ~101 becomes 010.

Read all about the Tilde operator in my detailed tutorial on this blog.

Sometimes, you’ll see the tilde operator in a Pandas DataFrame for indexing. Here’s an example:

import pandas as pd # Create a DataFrame
df = pd.DataFrame([{'User': 'Alice', 'Age': 22}, {'User': 'Bob', 'Age': 24}])
print(df) ''' User Age
0 Alice 22
1 Bob 24 ''' # Use Tilde to access all lines where user doesn't contain 'A'
df = df[~df['User'].str.contains('A')]
print(df) ''' User Age
1 Bob 24 '''

To improve your practical understanding, feel free to run this code in your browser in our interactive Python shell:

The tilde operator negates the Boolean values in the DataFrame: True becomes False and False becomes True.

You can see this in action when printing the result of different operations:

This is the original DataFrame in the code:

print(df) ''' User Age
0 Alice 22
1 Bob 24 '''

Now apply the contains operation to find all user names that contain the character 'A'.

print(df['User'].str.contains('A')) '''
0 True
1 False
Name: User, dtype: bool '''

The result is a DataFrame with Boolean values that indicate whether a user contains the character 'A' or not.

Let’s apply the Tilde operator on the result:

print(~df['User'].str.contains('A')) '''
0 False
1 True
Name: User, dtype: bool '''

Now, we use this DataFrame to access only those rows with users that don’t contain the character 'A'.

df = df[~df['User'].str.contains('A')]
print(df) ''' User Age
1 Bob 24 '''

Where to Go From Here?


Enough theory, let’s get some practice!

To become successful in coding, you need to get out there and solve real problems for real people. That’s how you can become a six-figure earner easily. And that’s how you polish the skills you really need in practice. After all, what’s the use of learning theory that nobody ever needs?

Practice projects is how you sharpen your saw in coding!

Do you want to become a code master by focusing on practical code projects that actually earn you money and solve problems for people?

Then become a Python freelance developer! It’s the best way of approaching the task of improving your Python skills—even if you are a complete beginner.

Join my free webinar “How to Build Your High-Income Skill Python” and watch how I grew my coding business online and how you can, too—from the comfort of your own home.

Join the free webinar now!



https://www.sickgaming.net/blog/2020/05/...dataframe/
Reply



Forum Jump:


Users browsing this thread:
1 Guest(s)

[-]
Discord

[-]
Active Threads
Microsoft - 4 new Flipgrid features ampl...
Last Post: xSicKxBot
Today 04:57 AM
» Replies: 0
» Views: 0
iOS 11.4 - 11.4.1 Jailbreak (Electra Jai...
Last Post: WilliamAsymn
Yesterday 11:21 PM
» Replies: 1
» Views: 804
(Indie Deal) RE8, Frontier, Slitherine, ...
Last Post: xSicKxBot
Yesterday 08:49 PM
» Replies: 0
» Views: 4
Microsoft - New hardware from Designed f...
Last Post: xSicKxBot
Yesterday 08:49 PM
» Replies: 0
» Views: 2
News - Guide: 30 Upcoming Nintendo Switc...
Last Post: xSicKxBot
Yesterday 08:49 PM
» Replies: 0
» Views: 3
News - Fortnite Skin Leak Roundup: Spide...
Last Post: xSicKxBot
Yesterday 08:48 PM
» Replies: 0
» Views: 4
kernel-debug-modules-4.18.0-305.25.1.el8...
Last Post: WilliamAsymn
Yesterday 04:14 PM
» Replies: 1
» Views: 34
Microsoft - Full-time food and travel vl...
Last Post: xSicKxBot
Yesterday 02:35 PM
» Replies: 0
» Views: 3
News - No Gravity Games Is Giving Away 1...
Last Post: xSicKxBot
Yesterday 02:34 PM
» Replies: 0
» Views: 4
News - Steam Autumn Sale Is Live Now: Ch...
Last Post: xSicKxBot
Yesterday 02:34 PM
» Replies: 0
» Views: 4

[-]
Twitter

[-]
Sponsored
Get the Deal of the Week at RefurBees.com



Discord Server © SickGaming.net 2012-2021