How to insert another column values in a column with their respective location?

Question

a=data["Col2"] a=a.dropna() a=pd.DataFrame(a) k=[] for i in data["Col1"]: k.append(i) o=1 for i in a.index: o=o+i k.insert(o,a['COLOR2'][i]) o+=1

But the problem here is the index of Col1 changes after 1st insertion. And after adding 1(o+=1), it still does not give the desired output.

There is multiple columns? Ouput is one column DataFrame ? — jezrael
– jezrael, Commented Sep 16, 2021 at 5:40

jezrael · Accepted Answer · 2021-09-16 05:48:53Z

1

If need new one column DataFrame from columns Col1, Col2 use:

df = data[['Col1','Col2']].stack().reset_index(drop=True).to_frame('Col')

edited Sep 16, 2021 at 5:48

answered Sep 16, 2021 at 5:39

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Agnij · Accepted Answer · 2021-09-16 05:46:25Z

Use a counter initialized to 1, such as -

a=data["Col2"] a=a.dropna() a=pd.DataFrame(a) k=[] for i in data["Col1"]: k.append(i) counter=1 for i in a.index: o=i+counter k.insert(o,a['Col2'][i]) counter+=1

Collectives™ on Stack Overflow

How to insert another column values in a column with their respective location?

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related