![]() |
|
[Tut] Tilde Python Pandas DataFrame - Printable Version +- Sick Gaming (https://sickgaming.net) +-- Forum: Programming (https://sickgaming.net/forum-76.html) +--- Forum: Python (https://sickgaming.net/forum-83.html) +--- Thread: [Tut] Tilde Python Pandas DataFrame (/thread-95097.html) |
[Tut] Tilde Python Pandas DataFrame - xSicKxBot - 05-17-2020 Tilde Python Pandas DataFrame Python’s Tilde Code: ~nCode: nCode: 0 to 1Code: 1 to 0Code: ~1Code: ~0Code: 1Code: ~101Code: 010Read 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: Code: 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: https://repl.it/@finxter/tildepythonpandas?lite=true The tilde operator negates the Booleanvalues in the DataFrame: Code: TrueCode: FalseCode: FalseCode: TrueYou can see this in action when printing the result of different operations: This is the original DataFrame in the code: Code: print(df) ''' User Age
0 Alice 22
1 Bob 24 '''Now apply the containsoperation to find all user names that contain the character Code: 'A'Code: 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 Code: 'A'Let’s apply the Tilde operator on the result: Code: 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 Code: 'A'Code: df = df[~df['User'].str.contains('A')]
print(df) ''' User Age
1 Bob 24 '''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! |