So i have a table from a 3rd party data source with formatting like this,
<code> Unnamed:0 Unnamed:1 Unnamed:2
0 NaN NaN NaN
1 NaN NaN NaN
2 No Program Budget
3 1 A 5500
</code>
<code> Unnamed:0 Unnamed:1 Unnamed:2
0 NaN NaN NaN
1 NaN NaN NaN
2 No Program Budget
3 1 A 5500
</code>
Unnamed:0 Unnamed:1 Unnamed:2
0 NaN NaN NaN
1 NaN NaN NaN
2 No Program Budget
3 1 A 5500
The actual column names that i want are on the 2nd index.
This is one example, and there are about tens of tables with similar problems.
I’m planning to use Python pandas to read these tables and to easily summarize the datas from the tables. How do i make it so the script could find the specific strings on the 2nd index and make it the DataFrame column heads?
Thanks in advance.