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 - concatenation

Pandas - concating multi-indexed dataframes keeps duplicate indizes

Hello I'm trying to read in multiple dfs of the same structre and concating them into a single one however the combined df somehow keeps duplicates in the indizes.... df1 = processUSAdata(2223) df2 = ...
test-img

Florian

python

pandas

dataframe

concatenation

multi-index

Votes: 0

Answers: 2

Latest Answer

It's probably because your index is not sorted: test = pd.concat([df1, df2]).set_index(['state', 'year']).sort_index() print(test) # Output population violent_crime theft gt...
test-img

Corralien

Pandas Inner Join with axis is one

I was working with inner join using concat in pandas. Using two DataFrames as below:- df1 = pd.DataFrame([['a',1],['b',2]], columns=['letter','number']) df3 = pd.DataFrame([['c',3,'cat'],['d',4,'dog'...
test-img

abhijeet

python

pandas

join

concatenation

Votes: 0

Answers: 2

Latest Answer

In Pandas.concat() axis argument defines whether to concat the dataframes based on index or columns. axis=0 // based on index (default value) axis=1 // based on columns when you Concatenated df1 and ...
test-img

Abhishek Saini

Concatenate value in each column based on cell value

Hello I need to concatenate the columns depending on whether the rows are null or have any value. I.e. I have data like this And I need get data like this The problem is that the columns I want to j...
test-img

Kateřina Chábová

excel

vba

concatenation

Votes: 0

Answers: 2

Latest Answer

If you asked for a VBA solution, please try the next code. It will process as many Value columns will be, and returns the processing result two columns after the last one. Using arrays, the code will ...
test-img

FaneDuru

Concatenate arrays using iteration in name with bash

I would like to concatenate unlimited numbers of arrays using shortest lines possible, so for this I did the code below: #!/bin/bash declare -a list1=("element1") declare -a list2=("ele...
test-img

antonio1

arrays

bash

iteration

concatenation

Votes: 0

Answers: 2

Latest Answer

You can use variable indirection: for i in {1..4} ; do ref="list$i[@]" list+=("${!ref}") done echo "${list[@]}"
test-img

choroba

Posts

Questions

Blogs

Jobs