How to convert first column of dataframe in to its headers-CodePudding

I have dataframe df:

O/P should be:

   a  b  c  d  e
0
1
2
3
4
5

I want column containing(a, b,c,d,e) as header of my dataframe.

Could anyone help?

CodePudding user response：

You may provide more details like the index and values of the expected output, the operation you wanna do, etc, so that we could give a specific solution to your case

Here is the solution:

import pandas as pd
import io
import numpy as np

data_string = """    columns_name
0   a
1   b
2   c
3   d
4   e
"""
df = pd.read_csv(io.StringIO(data_string), sep='\s ')

# Solution
df_result = pd.DataFrame(data=[[np.nan]*5],
                         columns=df['columns_name'].tolist())

CodePudding user response：

If your dataframe is pandas and its name is df. Try solving it with pandas:

Firstly convert initial df content to a list, afterwards create a new dataframe defining its columns with the list.

import pandas as pd

list = df[0].tolist()    #df[0] is getting the content of first column
dfSolved = pd.DataFrame([], columns = list)