teratail header banner
teratail header banner
質問するログイン新規登録

回答編集履歴

1

文字列消去の手段変更

2020/06/11 09:13

投稿

happy_boy
happy_boy

スコア9

answer CHANGED
@@ -12,11 +12,12 @@
12
12
  df = pd.read_csv(filename, names=("0","1","2","3","4","5"))
13
13
  df3 = df.set_index("3")
14
14
  df2 = df3.iloc[250:2250]
15
- df1 = df2.dropna(how="all", axis=1)
15
+ #df1 = df2.dropna(how="all", axis=1)
16
+ df1 = df2.drop(df.columns[[0,1,2,5]], axis=1)
16
17
  li.append(df1)
17
18
 
18
19
  df1 = pd.concat(li, axis=1, ignore_index=True)
19
- df_pr = df1.apply(lambda li:li/sum(li))
20
+ df_pr = df1.apply(lambda li:li/sum(abs(li)))
20
21
 
21
22
  result = df_pr.sum(axis=1)
22
23
  result.to_csv("result2.dat", header=None, sep=" ")