前提・実現したいこと
今,コードを組んでいるのですが,
下に示しているcsvファイルのある特定の番号の行を消したいです.
一番左が要素番号なのですが,
52行目以下と7650行以上7701以下の行,
51の倍数,51n+1(n=1~)の倍数の要素の行を消すにはどうすれば良いですか?
下記のようなコードを作ったのですが,エラーがでます.
df_new=df.drop(rem[i])
IndexError list index out of range
と出てきますが,どうすればいいですか....
Python3
1import pandas as pd 2 3df = pd.read_csv('aaa.csv') 4print(df) 5 6rem=[] 7 8 9for i in range(0, 7701): 10 if i<51: 11 rem.append(i) 12 if i%51==0: 13 rem.append(i) 14 if i%51==1: 15 rem.append(i) 16 if (i>7651) and (i<=7700): 17 rem.append(i) 18 19rem.pop(0) 20rem.pop(1) 21print(rem) 22 23num=len(rem) 24print(num) 25 26for l in range(num-1): 27 df_new = df.drop(rem[i])
##aaa.csv(Notepadで開いたデータ)
Python3
152,-0.05,0.05,0.298 253,-0.05,0.048,0.298 354,-0.05,0.046,0.298 455,-0.05,0.044,0.298 556,-0.05,0.042,0.298 657,-0.05,0.04,0.298 758,-0.05,0.038,0.298 859,-0.05,0.036,0.298 960,-0.05,0.034,0.298 1061,-0.05,0.032,0.298 1162,-0.05,0.03,0.298 1263,-0.05,0.028,0.298 1364,-0.05,0.026,0.298 1465,-0.05,0.024,0.298 1566,-0.05,0.022,0.298 1667,-0.05,0.02,0.298 1768,-0.05,0.018,0.298 1869,-0.05,0.016,0.298 1970,-0.05,0.014,0.298 2071,-0.05,0.012,0.298 2172,-0.05,0.01,0.298 2273,-0.05,0.008,0.298 2374,-0.05,0.006,0.298 2475,-0.05,0.004,0.298 2576,-0.05,0.002,0.298 2677,-0.05,0,0.298 2778,-0.05,-0.002,0.298 2879,-0.05,-0.004,0.298 2980,-0.05,-0.006,0.298 3081,-0.05,-0.008,0.298 3182,-0.05,-0.01,0.298 3283,-0.05,-0.012,0.298 3384,-0.05,-0.014,0.298 3485,-0.05,-0.016,0.298 3586,-0.05,-0.018,0.298 3687,-0.05,-0.02,0.298 3788,-0.05,-0.022,0.298 3889,-0.05,-0.024,0.298 3990,-0.05,-0.026,0.298 4091,-0.05,-0.028,0.298 4192,-0.05,-0.03,0.298 4293,-0.05,-0.032,0.298 4394,-0.05,-0.034,0.298 4495,-0.05,-0.036,0.298 4596,-0.05,-0.038,0.298 4697,-0.05,-0.04,0.298 4798,-0.05,-0.042,0.298 4899,-0.05,-0.044,0.298 49100,-0.05,-0.046,0.298 50101,-0.05,-0.048,0.298 51102,-0.05,-0.05,0.298 52103,-0.05,0.05,0.296 53104,-0.05,0.048,0.296 54105,-0.05,0.046,0.296 55106,-0.05,0.044,0.296 56107,-0.05,0.042,0.296 57108,-0.05,0.04,0.296 58109,-0.05,0.038,0.296 59110,-0.05,0.036,0.296 60111,-0.05,0.034,0.296 61112,-0.05,0.032,0.296 62113,-0.05,0.03,0.296 63114,-0.05,0.028,0.296 64115,-0.05,0.026,0.296 65116,-0.05,0.024,0.296 66117,-0.05,0.022,0.296 67118,-0.05,0.02,0.296 68119,-0.05,0.018,0.296 69120,-0.05,0.016,0.296 70121,-0.05,0.014,0.296 71122,-0.05,0.012,0.296 72123,-0.05,0.01,0.296 73124,-0.05,0.008,0.296 74125,-0.05,0.006,0.296 75126,-0.05,0.004,0.296 76127,-0.05,0.002,0.296 77128,-0.05,0,0.296 78129,-0.05,-0.002,0.296 79130,-0.05,-0.004,0.296 80131,-0.05,-0.006,0.296 81132,-0.05,-0.008,0.296 82133,-0.05,-0.01,0.296 83134,-0.05,-0.012,0.296 84135,-0.05,-0.014,0.296 85136,-0.05,-0.016,0.296 86137,-0.05,-0.018,0.296 87138,-0.05,-0.02,0.296 88139,-0.05,-0.022,0.296 89140,-0.05,-0.024,0.296 90141,-0.05,-0.026,0.296 91142,-0.05,-0.028,0.296 92143,-0.05,-0.03,0.296 93144,-0.05,-0.032,0.296 94145,-0.05,-0.034,0.296 95146,-0.05,-0.036,0.296 96147,-0.05,-0.038,0.296 97148,-0.05,-0.04,0.296 98149,-0.05,-0.042,0.296 99150,-0.05,-0.044,0.296 100151,-0.05,-0.046,0.296 101152,-0.05,-0.048,0.296 102153,-0.05,-0.05,0.296 103154,-0.05,0.05,0.294 104155,-0.05,0.048,0.294 105156,-0.05,0.046,0.294 106157,-0.05,0.044,0.294 107158,-0.05,0.042,0.294 108159,-0.05,0.04,0.294 109160,-0.05,0.038,0.294 110161,-0.05,0.036,0.294 111162,-0.05,0.034,0.294 112163,-0.05,0.032,0.294 113164,-0.05,0.03,0.294 114165,-0.05,0.028,0.294 115166,-0.05,0.026,0.294 116167,-0.05,0.024,0.294 117168,-0.05,0.022,0.294 118169,-0.05,0.02,0.294 119170,-0.05,0.018,0.294 120171,-0.05,0.016,0.294 121172,-0.05,0.014,0.294 122173,-0.05,0.012,0.294 123174,-0.05,0.01,0.294 124175,-0.05,0.008,0.294 125176,-0.05,0.006,0.294 126177,-0.05,0.004,0.294 127178,-0.05,0.002,0.294 128179,-0.05,0,0.294 129180,-0.05,-0.002,0.294 130181,-0.05,-0.004,0.294 131182,-0.05,-0.006,0.294 132183,-0.05,-0.008,0.294 133184,-0.05,-0.01,0.294 134185,-0.05,-0.012,0.294 135186,-0.05,-0.014,0.294 136187,-0.05,-0.016,0.294 137188,-0.05,-0.018,0.294 138189,-0.05,-0.02,0.294 139190,-0.05,-0.022,0.294 140191,-0.05,-0.024,0.294 141192,-0.05,-0.026,0.294 142193,-0.05,-0.028,0.294 143194,-0.05,-0.03,0.294 144195,-0.05,-0.032,0.294 145196,-0.05,-0.034,0.294 146197,-0.05,-0.036,0.294 147198,-0.05,-0.038,0.294 148199,-0.05,-0.04,0.294 149200,-0.05,-0.042,0.294 150201,-0.05,-0.044,0.294 151202,-0.05,-0.046,0.294 152203,-0.05,-0.048,0.294 153204,-0.05,-0.05,0.294 154205,-0.05,0.05,0.292 155206,-0.05,0.048,0.292 156207,-0.05,0.046,0.292 157208,-0.05,0.044,0.292 158209,-0.05,0.042,0.292 159210,-0.05,0.04,0.292 160211,-0.05,0.038,0.292 161212,-0.05,0.036,0.292 162213,-0.05,0.034,0.292 163214,-0.05,0.032,0.292 164215,-0.05,0.03,0.292 165216,-0.05,0.028,0.292 166217,-0.05,0.026,0.292 167218,-0.05,0.024,0.292 168219,-0.05,0.022,0.292 169220,-0.05,0.02,0.292 170221,-0.05,0.018,0.292 171222,-0.05,0.016,0.292 172223,-0.05,0.014,0.292 173224,-0.05,0.012,0.292 174225,-0.05,0.01,0.292 175226,-0.05,0.008,0.292 176227,-0.05,0.006,0.292 177228,-0.05,0.004,0.292 178229,-0.05,0.002,0.292 179230,-0.05,0,0.292 180231,-0.05,-0.002,0.292 181232,-0.05,-0.004,0.292 182233,-0.05,-0.006,0.292 183234,-0.05,-0.008,0.292 184235,-0.05,-0.01,0.292 185236,-0.05,-0.012,0.292 186237,-0.05,-0.014,0.292 187238,-0.05,-0.016,0.292 188239,-0.05,-0.018,0.292 189240,-0.05,-0.02,0.292 190241,-0.05,-0.022,0.292 191242,-0.05,-0.024,0.292 192243,-0.05,-0.026,0.292 193244,-0.05,-0.028,0.292 194245,-0.05,-0.03,0.292 195246,-0.05,-0.032,0.292 196247,-0.05,-0.034,0.292 197248,-0.05,-0.036,0.292 198249,-0.05,-0.038,0.292 199250,-0.05,-0.04,0.292 200251,-0.05,-0.042,0.292 201252,-0.05,-0.044,0.292 202253,-0.05,-0.046,0.292 203254,-0.05,-0.048,0.292 204255,-0.05,-0.05,0.292 205256,-0.05,0.05,0.29 206257,-0.05,0.048,0.29 207258,-0.05,0.046,0.29 208259,-0.05,0.044,0.29 209260,-0.05,0.042,0.29 210261,-0.05,0.04,0.29 211262,-0.05,0.038,0.29 212263,-0.05,0.036,0.29 213264,-0.05,0.034,0.29 214265,-0.05,0.032,0.29 215266,-0.05,0.03,0.29 216267,-0.05,0.028,0.29 217268,-0.05,0.026,0.29 218269,-0.05,0.024,0.29 219270,-0.05,0.022,0.29 220271,-0.05,0.02,0.29 221272,-0.05,0.018,0.29 222273,-0.05,0.016,0.29 223274,-0.05,0.014,0.29 224275,-0.05,0.012,0.29 225276,-0.05,0.01,0.29 226277,-0.05,0.008,0.29 227278,-0.05,0.006,0.29 228279,-0.05,0.004,0.29 229280,-0.05,0.002,0.29 230281,-0.05,0,0.29 231282,-0.05,-0.002,0.29 232283,-0.05,-0.004,0.29 233284,-0.05,-0.006,0.29 234285,-0.05,-0.008,0.29 235286,-0.05,-0.01,0.29 236287,-0.05,-0.012,0.29 237288,-0.05,-0.014,0.29 238289,-0.05,-0.016,0.29 239290,-0.05,-0.018,0.29 240291,-0.05,-0.02 241・ 242・ 243・ 2447701,-0.05,-0.05
回答1件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2018/12/21 18:08
2018/12/21 18:15
2018/12/21 18:24
2018/12/21 18:28
2018/12/21 18:36
2018/12/21 18:37
2018/12/21 18:40
2018/12/21 18:40
2018/12/21 18:43 編集
2018/12/21 18:46
2018/12/21 18:47
2018/12/21 18:48
2018/12/21 19:01
2018/12/21 19:08
2018/12/21 19:30 編集