Python - 将列移动到 Pandas DataFrame 中的第一个位置?
使用pop()弹出列,并使用插入insert()methodi.e。移动一列。首先,创建一个包含3列的DataFrame-
dataFrame = pd.DataFrame( { "Student": ['Jack', 'Robin', 'Ted', 'Marc', 'Scarlett', 'Kat', 'John'],"Result": ['Pass', 'Fail', 'Pass', 'Fail', 'Pass', 'Pass', 'Pass'],"Roll Number": [ 5, 10, 3, 8, 2, 9, 6] } )
通过首先弹出列,将列“卷号”移动到第一个位置-
shiftPos = dataFrame.pop("Roll Number")
在第一个位置插入列-
dataFrame.insert(0, "Roll Number", shiftPos)
示例
以下是代码-
import pandas as pd #创建数据帧 dataFrame = pd.DataFrame( { "Student": ['Jack', 'Robin', 'Ted', 'Marc', 'Scarlett', 'Kat', 'John'],"Result": ['Pass', 'Fail', 'Pass', 'Fail', 'Pass', 'Pass', 'Pass'],"Roll Number": [ 5, 10, 3, 8, 2, 9, 6] } ) print"DataFrame ...\n",dataFrame # move column "Roll Number" to 1st position shiftPos = dataFrame.pop("Roll Number") #在第一个位置插入列 dataFrame.insert(0, "Roll Number", shiftPos) print"\nUpdated DataFrame after moving a column to the first position...\n",dataFrame输出结果
这将产生以下输出-
DataFrame ... Result Roll Number Student 0 Pass 5 Jack 1 Fail 10 Robin 2 Pass 3 Ted 3 Fail 8 Marc 4 Pass 2 Scarlett 5 Pass 9 Kat 6 Pass 6 John Updated DataFrame after moving a column to the first position... Roll Number Result Student 0 5 Pass Jack 1 10 Fail Robin 2 3 Pass Ted 3 8 Fail Marc 4 2 Pass Scarlett 5 9 Pass Kat 6 6 Pass John