1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| import pandas as pd
df=pd.read_excel('mots.xlsx', keep_default_na=False)
Titres=list(df.columns)
mot=list()
for i in range(0,len(Titres)):
print(i)
mot.insert(i,list(df[Titres[i]]))
print(mot)
for j in range(0,len(mot)):
mot[j].remove('')
0
1
[['Bol bleu', 'bol rouge', 'bol vert'], ['assiette verte', '', '']]
---------------------------------------------------------------------------
ValueError Traceback (most recent call last)
<ipython-input-74-4fafed27c4a3> in <module>()
10 print(mot)
11 for j in range(0,len(mot)):
---> 12 mot[j].remove('')
ValueError: list.remove(x): x not in list |