python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - combinations

Creating new columns in pandas dataframe as summed permutations of other columns

Hopefully this simple explanation will get across what I'm trying to do. Suppose I had a Pandas dataframe that had the following columns: A B C D E 1 2 4 6 4 3 4 1 2 3 4 7 4 1 4 Does anyone know a w...
test-img

Richard Dixon

python

pandas

combinations

Votes: 0

Answers: 4

Latest Answer

Using the underlying numpy array for efficiency. from itertools import combinations a = df.to_numpy() df2 = pd.DataFrame(np.vstack([a[:,list(c)].sum(1) for c in combinat...
test-img

mozway

Sum all combinations of 2 columns from 2 dataframes

I have 2 dataframes df1 and df2 (same index and number of rows), and I would like to create a new dataframe which columns are the sum of all combinations of 2 columns from df1 and df2, example : input...
test-img

AJM7564

python

pandas

dataframe

sum

combinations

Votes: 0

Answers: 2

Latest Answer

Use MultiIndex.from_product for all combinations and sum DataFrames with repeated values by DataFrame.reindex: mux = pd.MultiIndex.from_product([df1.columns, df2.columns]) df = df1.reindex(mux, level...
test-img

jezrael

R: Recreating the Travelling Salesman Problem

I am working with the R programming language. I am trying to recreate the travelling salesman problem. The travelling salesman problem is a problem where a salesman has to visit "n" number ...
test-img

stats_noob

r

time

combinations

distance

Votes: 0

Answers: 1

Latest Answer

To calculate the cumulative distance for all 6! routes for the given final_data could be done like this: set.seed(123) data_1 = data.frame(id = c(1,2,3), long = rnorm(3, -74, 1 ), lat = rnorm(3, 40, 1...
test-img

r2evans

Apply a function of every row in a dataset using elements of a second dataset in R

I have two datasets, the firs one called activos_full has this structure: "usuario","name" "BotInventory","InventoryBot (PC parts, Ryzen, RTX, console, toys)" &...
test-img

rcr_aagr

r

function

dataset

combinations

apply

r

function

dataset

combinations

apply

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs