擅长:python、mysql、java
<p>尝试使用列的新名称创建列表</p>
<pre><code>import pandas as pd
df = pd.DataFrame({'Testingthislongcolumnthatwouldbreakoracle': {0: 3, 1: 3, 2: 3},
'goodcolum': {0: 1, 1: 1, 2: 1},
'goodcolum2': {0: 2, 1: 2, 2: 2}})
col_names = []
for columnName in df:
charlength=len(columnName)
vowels=sum(list(map(columnName.lower().count, "aeiou")))
if charlength >= 31:
if charlength - vowels <= 31:
col_names.append(''.join(char for char in columnName if char not in 'aeiouAEIOU'))
else:
col_names.append(columnName)
print(df)
df.columns=col_names
print(df)
</code></pre>