python dataframe选取除了'rating', 'pages', 'numRatings', 'likedPercent', 'language_English', 'language_Filipino; Pilipino', 'language_Georgian', 'language_Greek, Modern (1453-)', 'language_Hungarian', 'language_Polish', 'language_Portuguese', 'language_Spanish', 'language_U', 'bookFormat_Capa Mole', 'bookFormat_Leather Bound', 'bookFormat_Mass Market Paperback', 'bookFormat_Rústica', 'bookFormat_Slipcased Hardcover', 'bookFormat_U', 'bookFormat_Unknown Binding', 'price'列的其它列
时间: 2023-08-06 13:16:49 浏览: 64
你可以使用以下代码选取除了指定列以外的其它列:
```python
import pandas as pd
# 创建示例数据
data = {'name': ['Alice', 'Bob', 'Charlie'],
'age': [25, 30, 35],
'gender': ['F', 'M', 'M'],
'rating': [4.5, 3.8, 4.2],
'pages': [320, 256, 432],
'numRatings': [1000, 500, 800],
'likedPercent': [85, 70, 90],
'language_English': [1, 0, 1],
'language_Filipino; Pilipino': [0, 1, 0],
'language_Georgian': [0, 0, 1],
'language_Greek, Modern (1453-)': [1, 1, 0],
'language_Hungarian': [0, 1, 0],
'language_Polish': [1, 0, 0],
'language_Portuguese': [0, 1, 1],
'language_Spanish': [1, 1, 0],
'language_U': [0, 0, 1],
'bookFormat_Capa Mole': [1, 0, 0],
'bookFormat_Leather Bound': [0, 1, 0],
'bookFormat_Mass Market Paperback': [0, 0, 1],
'bookFormat_Rústica': [1, 0, 1],
'bookFormat_Slipcased Hardcover': [0, 1, 0],
'bookFormat_U': [0, 0, 1],
'bookFormat_Unknown Binding': [0, 1, 0],
'price': [20.5, 25.0, 18.9]}
df = pd.DataFrame(data)
# 选取除了指定列以外的其它列
cols_to_keep = [col for col in df.columns if col not in ['rating', 'pages', 'numRatings', 'likedPercent',
'language_English', 'language_Filipino; Pilipino',
'language_Georgian', 'language_Greek, Modern (1453-)',
'language_Hungarian', 'language_Polish', 'language_Portuguese',
'language_Spanish', 'language_U', 'bookFormat_Capa Mole',
'bookFormat_Leather Bound', 'bookFormat_Mass Market Paperback',
'bookFormat_Rústica', 'bookFormat_Slipcased Hardcover',
'bookFormat_U', 'bookFormat_Unknown Binding', 'price']]
df_selected = df[cols_to_keep]
print(df_selected)
```
输出结果为:
```
name age gender
0 Alice 25 F
1 Bob 30 M
2 Charlie 35 M
```