迭代CSV中的每一列，并对每一列应用加密

Question

您好，我是python新手，我尝试将pycrypt.caesar.encrypt（column\u name，column\u number）函数应用于CSV中要加密的每个列。我试过这样的东西

import pycrypt
import pandas as pd

df = pd.read_csv('test.csv')
print(df)
#col=df.columns
#print(col)
leng=range(len(df.columns))
print(leng)
j=0
for col in df.columns[0:,] and j in leng:
     #print(col)
     df['col']=df['col'].apply(lambda col: pycrypt.caesar.encrypt(col,j))
     print(df)

它抛出一个错误

Traceback (most recent call last):
File "C:/Users/kalya/AppData/Local/Temp/Pseudo.py/main.py", line 12, in 
<module>
for col in df.columns[0:,] and j in leng:
 File "C:\Python38\lib\site-packages\pandas\core\indexes\base.py", line 2419, 
 in __nonzero__
  raise ValueError(
ValueError: The truth value of a Index is ambiguous. Use a.empty, a.bool(), 
a.item(), a.any() or a.all().

我做错了什么？我想通过循环对csv中的所有列进行迭代加密。请引导我

Answer 1

如果要迭代数据帧中的列，并对每列应用不同的ceasar移位，可以执行以下操作：

for index,column in enumerate(df):
    df[column]=df[column].apply(lambda x: pycrypt.caesar.encrypt(x,index))

print(df)