Delete column and make next row column?

Question

If I have a column that I want to delete entirely and make the very next row the columns how can I do that?

For example if I have

unnamed column 0 | unnamed column 1 | unnamed column 2 
    Year            Month               Day
    1900             04                  11

New df

Year |  Month | Day
1900     04      11

Thanks

You can use skiprows in pandas.read_csv(). Is that what you are looking for? — Param Siddharth
– Param Siddharth, Commented Aug 20, 2020 at 16:32

merlo94 · Accepted Answer · 2020-08-20 16:42:00Z

3

In case you are using pandas, would this work?

import pandas as pd

old_df = pd.DataFrame([["a", "b", "c"], ["Year", "Month", "Day"], [1990, 4, 11]])
new_df = old_df.loc[2:, :]
new_df.columns = old_df.loc[1, :]

print(old_df)
print(new_df)

answered Aug 20, 2020 at 16:42

merlo94

461 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

scoop96 · Accepted Answer · 2020-08-20 16:39:24Z

0

Create another table with the structure that you want
migrate the data with the conversion
Delete the original table

Else you can make a function or some other process in order to access the data via
...
if Table.unamedCollum0 is like 'Year' then Table.unamedCollum0 = Table.unamedCollum0.old
...

answered Aug 20, 2020 at 16:39

scoop96

114 bronze badges

Collectives™ on Stack Overflow

Delete column and make next row column?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related