filter one dataframe by another

ByAnurag batra July 31, 2022June 30, 2022

df1 = pd.DataFrame({'c': ['A', 'A', 'B', 'C', 'C'],
                    'k': [1, 2, 2, 2, 2],
                    'l': ['a', 'b', 'a', 'a', 'd']})
df2 = pd.DataFrame({'c': ['A', 'C'],
                    'l': ['b', 'a']})
keys = list(df2.columns.values)
i1 = df1.set_index(keys).index
i2 = df2.set_index(keys).index
df1[~i1.isin(i2)]

Here is what the above code is Doing:
1. Set the index of df1 and df2 to the columns specified in keys.
2. Get the index of df1 and df2.
3. Use the index of df1 to select the rows of df1 that are not in the index of df2.

Python Examples

pandas tuple from two columns

ByAnurag batra June 24, 2022May 21, 2022

df[‘new_col’] = list(zip(df.lat, df.long)) Here is what the above code is Doing: 1. Create a new column called ‘new_col’ 2. Zip the values of the ‘lat’ and ‘long’ columns into a list 3. Assign the list to the ‘new_col’ column

Python Examples

add header to table in pandas

ByAnurag batra May 30, 2022May 20, 2022

# python 3.x import pandas as pd import numpy as np df = pd.DataFrame(data=np.random.randint(0, 10, (6,4))) df.columns=[“a”, “b”, “c”, “d”] print(df) Here is what the above code is Doing: 1. Create a DataFrame with random integers from 0 to 10. 2. Set the column names to “a”, “b”, “c”, and “d”. 3. Print the DataFrame.

Python Examples

just testing out our code

ByAnurag batra July 27, 2022June 30, 2022

select * from user where first_name REGEXP ‘^john$’; Here is what the above code is Doing: 1. Select all columns from the user table. 2. Where the first_name column matches the regular expression ‘^john$’. The regular expression ‘^john$’ is looking for a string that starts with ‘john’ and ends with ‘john’. The ^ and $…

Python Examples

python hash

ByAnurag batra April 17, 2022April 14, 2022

import hashlib hash_object = hashlib.sha256(b’Hello World’) hex_dig = hash_object.hexdigest() print(hex_dig) Here is what the above code is Doing: 1. We import the hashlib library. 2. We create a variable named hash_object. 3. We use the hashlib.sha256() function to create a SHA-256 hash object. 4. We use the .update() function to pass the string ‘Hello World’…

Python Examples

discord.py say something

ByAnurag batra May 5, 2022April 14, 2022

#Discord.py rewrite #python 3+ @bot.command(name=’say_hi’, help=’Run this command when your lonely!’) async def sayhi(ctx): #This code will say “Hi, @username!” #this uses an ‘f’ befoe a string so I can input the username #ctx has many propertys, including .send .author and .content (there are more) await ctx.send(f”Hi, {ctx.author.mention}!”) Here is what the above code is…

Python Examples

how to make a minute counter in python

ByAnurag batra July 25, 2022June 30, 2022

counter = 1 print(counter) import time while True: time.sleep(60) counter += 1 print(counter) #this adds one to the counter every 60 seconds Here is what the above code is Doing: 1. It’s importing the time module. 2. It’s creating a while loop that will run forever. 3. It’s telling the program to wait for 60…

Similar Posts