将表中的偶数行,奇数列提取出来成为一个新的表
这个表本来是个excel文件但是文件不能上传
import pandas as pd
data = pd.read_excel(filename)
data_v = data.values
pd.DataFrame([[data_v[j, i] for i in range(0, len(data.columns), 2)] for j in range(1, len(data_v), 2)], columns = list(data.columns)[::2]).to_excel(filename + '_new.xlsx', index = False)
import pandas as pd
data = {'a': [1, 2, 3, 4, 5, 6],'b': ['a', 'b', 'c', 'd', 'f', 'g'],'c': [11, 22,33, 44, 55, 66],}
df = pd.DataFrame(data = data)
print(df.iloc[::2, 1::2])
```python
```