这是我的解决方案-尚未弄清楚优化部分,但考虑到相当大的数据集,应该可以很好地处理它-
import pandas as pd
df = pd.read_csv('temp.csv')
df['New_Col'] = "Start"
df.loc[1::2,"New_Col"] = "Stop"
print df['New_Col']
输出-
0 Start
1 Stop
2 Start
3 Stop
4 Start
5 Stop
6 Start
7 Stop
8 Start
9 Stop
10 Start
11 Stop
12 Start
13 Stop
14 Start
15 Stop
16 Start
17 Stop
18 Start
19 Stop
20 Start
21 Stop
22 Start
23 Stop
24 Start
25 Stop
26 Start
27 Stop
28 Start
29 Stop
...
116 Start
117 Stop
118 Start
119 Stop
120 Start
121 Stop
122 Start
123 Stop
124 Start
125 Stop
126 Start
127 Stop
128 Start
129 Stop
130 Start
131 Stop
132 Start
133 Stop
134 Start
135 Stop
136 Start
137 Stop
138 Start
139 Stop
140 Start
141 Stop
142 Start
143 Stop
144 Start
145 Stop
Name: New_Col, dtype: object