I’m trying to search for key terms that are contained in one dataframe in another, returning each one when it is found in the second dataframe. My code below words to extract the keywords. However, some of the keywords overlap and it only pulls the first result it finds, when I would like it to pull as …
Tag: pandas
Check for value of an dataframe exists in another and set values in a specific way accounting for duplicates
I have two dataframes: In df1, i got an order of id’s assigned to people, each person can have at most 2 id’s: df1: In df2, i got a list of payments and id’s for these people but not arranged: df2: What i’m looking for is a way to create a df3 that organizes payments in the specific or…
Converting dictionary into dataframe
Hello i am trying to convert a dictionary into a dataframe, containing results from a search on amazon (I am using an API.). I would like each product to be a row in the dataframe with the keys as column headers. However there is some keys in the beginning, that i am not interested in having in the table. Bel…
How to sort pandas dataframe in ascending order using Python
I have a dataframe like this : Columns’ types with print(df.dtypes) : Expected Output : I have a dataframe like df. When I do : But nothing happen even by adding ascending = True or False. Could you give the way pls to order this dataframe as above ? If possible can you give the 2 possibilites like orde…
Iterating through multiple rows using multiple values from nested dictionary to update data frame in python
I created nested dictionary to keep multiple values for each combination, example rows in the dictionary is as follows:- dict = {‘A’: {B: array([1,2,3,4,5,6,7,8,9,10]), C: array([array([1,2,3,4,5,6,7,8,9,10],…}} There are multiple As and in that multiple arrays for each array. Now I want to …
Pandas – get values from list of tuples and map them to values on new columns based on condition
I have this dataframe, df_match: where each row on from_home_player_1_to_home_player_11 column keeps a list of tuples, like so: df_match.sample(1): GOAL Now I would like to set X/Y coordinates for each player on the field (using only coord X here in order to simplify it), per match (row) Each player on from_h…
Replacing values using dictionary
What are the reasons why are regex replacment doesn’t work? I have tried ensuring no excess spaces. When I do df.loc[df[‘column’]==”and another reason with her”] nothing has changed. Answer Please use df.replace(regex=dict)
Exporting values to existing excel file to same column
I’m running a script every day to get the date and values that I save as a data frame. Something like this: If I use the command ‘df.to_csv(“file.csv”)’ I get my data frame in an excel sheet. However, when I run the script for the following day (12/02/2021) I want to get the valu…
Pandas dataframe custom formatting string to time
I have a dataframe that looks like this I need to get every value in this column DEP_TIME to have the format hh:mm. All cells are of type string and can remain that type. Some cells are only missing the colon (rows 0 to 3), others are also missing the leading 0 (rows 4+). Some cells are empty and should
How to select rows where date is in index in Python Pandas DataFrame?
I have DataFrame in Pythonlike below where data is in index (we can name this column “date”): and I would like to select all column of this DF where data in index is > than 01.01.2020, how can I do it? (be aware that date is in index). Answer Use boolean indexing: Or: