Assuming I have a toy model df which lists the model of the car and customer rating of one car showroom. Using plotly express, I created pie charts of percentage of cars by model and by Cust_rating, respectively as two separate graphs: Now, I want to create subplots, and all the ways of doing it using the documentation are throwing

# Tag: pandas

## Updating columns of list based on match

Purpose The main purpose is to be able to compute the share of resources used by node i in relation to its neighbors: r_i / sum_j^i{r_j} where r_i are node i resources and sum_j^i{r_j} is the sum of i’s neighbors’ resources. I am open to any R, python or eventually stata solutions, that are able to achieve this task on

## How to merge multiple columns of a dataframe using regex？

I have a df which as following Here what I want to do is combine those columns and we have two rules: If a column removes _C{0~9} or _C{0~9}{0~9} or _C{0~9}{0~9}{0~9} is equal to another column, these two columns can be combined. Let’s take number_C1_E1 number_C2_E2 number_C3_E1 as an example, here number_C1_E1 and number_C3_E1 can be combined because they are

## Combine rows and average column if another column is minimum

I have a pandas dataframe: Basically, I would like to average the Power for each server but only if the difference is minimum. For example, if you look at the ‘PhysicalWindows1’ server, I have 3 rows, two have a diff of 100, and one has a diff of 500. Since I have two rows with a diff of 100, I

## How do I separate measurement value and unit into their respective columns if they appear together in DataFrame?

I have a DataFrame which contains measurements; e.g., weight, height, etc. However, sometimes the measurement column contains units together with values. Therefore, I would like to separate measurement values and units if they are together in DataFrame. Eg., In the below DataFrame, df, the height value and unit of the first entry are in respective columns. However, the value column

## Substitute column values of a dataframe with the corresponding items in an array

I have a column in a dataframe which contains an array of numbers from 1 to 5 and I have an array containing five words. I would like to find the simplest, most compact and most elegant way in Python to “in place” replace the numbers in the column with the corresponding words. For example: I am certain that the

## Sort the products based on the frequency of changes in customer demand

Imagine following dataframe is given. I have columns products, custome_demand_date (every week there is new customer demand for products per upcoming months) and months with quantity demand. How can I determine which product has experienced the most frequent changes in customer demand over the months, and sort the products in descending order of frequency of change? I have tried to

## Loop through a dataframe, using specific values for individual dates

I have a dataframe that looks like the below. I want to create a new column titled ‘Daily Change’ which will be the result of the first ‘Open’ price of each day divided by the ‘Open’ price for each 5 minute interval. Once the dates changes I need to the first open price of that day and so on. This

## Python panda’s dataframe boolean Series/Column based on conditional next columns

I’m having trouble describing exactly what I want to achieve. I’ve tried looking here on stack to find others with the same problem, but are unable to find any. So I will try to describe exactly what I want and give you a sample setup code. I would like to have a function that gives me a new column/pd.Series. This

## Why can’t I save my scraped html table to pandas dataframe?

I have a python script that scrapes a html table. When I try to save my scraped data to pandas dataframe, I get an error. Please help me check what am doing wrong? Here is my codeblock Here is the error i get I want to save the above scraped values into pandas dataframe. That’s my aim. Please help if