本文介绍了 pandas :多栏成一栏的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有以下数据(2列4行):
I have the following data (2 columns, 4 rows):
Column 1: A, B, C, D Column 2: E, F, G, H我正在尝试将各列合并为一列,看起来像这样(1列,8行):
I am attempting to combine the columns into one column to look like this (1 column, 8 rows):
Column 3: A, B, C, D, E, F, G, H我正在使用pandas DataFrame,并尝试使用其他功能但没有成功(append,concat等).任何帮助将不胜感激!
I am using pandas DataFrame and have tried using different functions with no success (append, concat, etc.). Any help would be most appreciated!
推荐答案更新
pandas为此 stack ,您会看到其他答案.
pandas has a built in method for this stack which does what you want see the other answer.
这是我多年前认识stack之前的第一个答案:
This was my first answer before I knew about stack many years ago:
In [227]: df = pd.DataFrame({'Column 1':['A', 'B', 'C', 'D'],'Column 2':['E', 'F', 'G', 'H']}) df Out[227]: Column 1 Column 2 0 A E 1 B F 2 C G 3 D H [4 rows x 2 columns] In [228]: df['Column 1'].append(df['Column 2']).reset_index(drop=True) Out[228]: 0 A 1 B 2 C 3 D 4 E 5 F 6 G 7 H dtype: object更多推荐
pandas :多栏成一栏
发布评论