Как взорвать пандас данных, который имеет нули в некоторых рядах, но заселен в других ⇐ Python

[Anonymous]

Так что у меня есть много данных о данных, которое нужно взорваться. Они выглядят примерно так: < /p>
df = pd.DataFrame({'A': [1, [11,22], [111,222]],
'B': [2, [33,44], float('nan')],
'C': [3, [55,66], [333,444]],
'D': [4, [77,88], float('nan')]
})
< /code>
+-----------+---------+-----------+---------+
| A | B | C | D |
+-----------+---------+-----------+---------+
| 1 | 2 | 3 | 4 |
+-----------+---------+-----------+---------+
| [11,22] | [33,44] | [55,66] | [77,88] |
+-----------+---------+-----------+---------+
| [111,222] | NaN | [333,444] | NaN |
+-----------+---------+-----------+---------+
< /code>
Typically if a column couldn't be exploded I'd just remove it from the column list like so:
colList = df.columns.values.tolist()
colList.remove("B")
colList.remove("D")
df = df.explode(colList)
< /code>
But that would leave me with a dataframe that looks like:
+-----+---------+-----+---------+
| A | B | C | D |
+-----+---------+-----+---------+
| 1 | 2 | 3 | 4 |
+-----+---------+-----+---------+
| 11 | [33,44] | 55 | [77,88] |
+-----+---------+-----+---------+
| 22 | [33,44] | 66 | [77,88] |
+-----+---------+-----+---------+
| 111 | NaN | 333 | NaN |
+-----+---------+-----+---------+
| 222 | NaN | 444 | NaN |
+-----+---------+-----+---------+
< /code>
I still need to explode those columns (B and D in example), but if I do, it'll throw an error due to the nulls. How can I successfully explode dataframes with this sort of problem?

Подробнее здесь: https://stackoverflow.com/questions/779 ... pulated-in