I have a sorted DataFrame by company_name: I would like to select the rows which have the first 3 letters in common and have the following rows ending with “u” or “w”. Ideally I would like the result to look like this (including the “main” name as an extra column). Assume t…
Tag: pandas
how to import data from a excel list into a loop for a api python
I am connecting an API and everything is going fine, now I have one problem, I have a data excel list like this: Name Secondname Age alex test 2020-02-03 pieter guy 2020-04-04 in my script i have a variable called: name. Now i want to make a script that takes everyloop 1 line of data. so loop 1: ALEX TEST
Pandas multiindex dataframe – Selecting max from one index within multiindex multi column
I have below Dataframe how to find dedicated result. I have found multi row maximum with column A. result must be : How can I find maximum with col_1? Answer based on your desired example output, your question appears to be: how do I return the rows with the largest col_1 value per Caps group. Your example in…
How to resize x axis
I want to resize the x-axis range, but I don’t know how to do that. The range I want to resize is [under 20, under 40, under 60, under 80]. X represent age and Y represent survived rate Answer Put your data into age groups before plotting: If you want more polished labels:
how to get last 10 business days if
I want to create dataframe based on last 10 business days. Also it should check whether the day is public holiday or not. I have a list of public holiday. List of public holiday is: Holiday 2021-01-26 2021-03-11 2021-03-29 2021-04-02 2021-04-14 2021-04-21 2021-05-13 2021-07-21 2021-08-19 2021-09-10 2021-10-15…
Plotting graph from data frame
Plotting the graph for both South Asia and Eastern Asia using the above function is showing the same countries and same graphs .What mistake am I doing while writing the above code, I can’t figure that out? enter image description here Answer The problem is with your function. Remove the for loop and it…
Removing one source value when there are multiple sources
I have the following dataset: I wanna reorganize the dataset in the following way: In word, in each year, for each category if we have value from multiple source (A,B), we will drop the source value of B. But if there is only source value of B, then we will keep that. I have tried to fix it using df.groupby()…
How to assign value to particular column in pandas dataframe based on different conditions?
I have a dataset with around 40,000 rows each representing a record in dataset. One of the features named ‘region_code’ is categorical in nature but is represented using integer. It is similar to pincode/zipcode. There are around 5316 unique ‘region_code’ values and these Region_Codes …
Pandas return separate column value in current index if two separate columns match
Say I have the following data frame: I have been trying to: Loop through Column A to find a matching value in Column B If there is a match in Column B I want to grab the value in Column C for the current index and create a Column D with that value. Given the example data frame above, below
Creating a column with conditions over multiple rows
I have the next DataFrame: I need to create a column considering the variation on the other column. Following this result: Letter Number a 1 a 0 a 0 a 0 b 1 b 0 b 0 c 1 c 0 a 1 Every time the letter change, I need to put a 1. Answer shift I’m assuming that df