apologies if this sounds like a dumb question, I haven’t worked on Pandas for a long time.
I’ve two data frames, Nodes:
I want the final output to look like this, total would be 7*10= 70 rows:
In R, I use the following piece of code to do this:
prem_subset = merge(nodes, subset(rate_card, select=c("service", "duration","rate")),all=TRUE) where I'm only selecting some columns from my original rate_card df
I can’t find the Pandas equivalent for this.
IIUC I believe you are looking for pandas
merge with option
select_cols = ['service', 'duration', 'rate'] nodes.merge(rate_card[select_cols], how='cross')