python df 合并_在同一df Python / Pandas中合并列

I'm new to the programming world and can't figure out how to concatenate columns in pandas. I'm not looking to join these columns, but rather stack them on top of each other.

This is the code I have so far:

import pandas as pd

import numpy as np

df = pd.read_excel("C:\\Users\\Kit Wesselhoeft\\Documents\\NEM\\Northend Manufacturing_deletecol.xlsx")

print(df)

df = pd.concat(['A','A'])

print(df)

I want to combine all the columns so that all the A's sit on top of each other, Same with the B's - E's.

How can I do this? Am I missing something?

解决方案

The following example is relevant when you exactly know where your columns are. Building on ALollz's code:

import numpy as np

import pandas as pd

np.random.seed(123)

df =