删除除包含X值的列以外的所有列

import pandas as pd

# 假设df是你的DataFrame对象
df = pd.read_csv('yourfile.csv')

# 筛选出包含'X'的列
filtered_columns = [col for col in df.columns if 'X' in df[col].values]

# 创建一个新的DataFrame，只包含筛选出的列
new_df = df[filtered_columns]

# 将新的DataFrame保存到CSV文件
new_df.to_csv('filtered_file.csv', index=False)

SELECT * FROM your_table WHERE column_name LIKE '%X%';

Sub RemoveColumnsWithoutX()
    Dim ws As Worksheet
    Set ws = ActiveSheet
    
    Dim lastCol As Long
    lastCol = ws.Cells(1, ws.Columns.Count).End(xlToLeft).Column
    
    Dim col As Long
    For col = lastCol To 1 Step -1
        If Not Application.WorksheetFunction.CountIf(ws.Columns(col), "*X*") > 0 Then
            ws.Columns(col).Delete
        End If
    Next col
End Sub