/Python/Creating a new DataFrame from itertuples, namedtuple using a series or list()

Creating a new DataFrame from itertuples, namedtuple using a series or list()

import pandas as pd

# source DataFrame
df = pd.DataFrame({'a': [1,2], 'b':[3,4]})
# empty DataFrame
df_new_fromAppend = pd.DataFrame(columns=['x','y'], data=None)

for r in df.itertuples():
    # create new DataFrame from itertuples() via list() ([1:] for skipping the index):
    df_new_fromList = pd.DataFrame([list(r)[1:]], columns=['c','d'])
    # or create new DataFrame from itertuples() via Series (drop(0) to remove index, T to transpose column to row) 
    df_new_fromSeries = pd.DataFrame(pd.Series(r).drop(0)).T
    # or use append() to insert row into existing DataFrame ([1:] for skipping the index):
    df_new_fromAppend.loc[df_new_fromAppend.shape[0]] = list(r)[1:]

print('df_new_fromList:')
print(df_new_fromList, '\n')
print('df_new_fromSeries:')
print(df_new_fromSeries, '\n')
print('df_new_fromAppend:')
print(df_new_fromAppend, '\n')

Source: stackoverflow.com

Similar codes

21 votes233 views4 answers
Send dm discord py
Python
102 votes137 views6 answers
Python files
Python
15 votes137 views4 answers
How to stop python for some time in python
Python
12 votes149 views1 answer
X=x+1
Python
-1 vote152 views2 answers
Httplib python
Python
0 vote165 views1 answer
Symbol to make things not equeal to something in python
Python
1 vote136 views2 answers
Add column array python
Python
0 vote135 views2 answers
Find index of null values pandas
Python
18 votes136 views3 answers
Tkinter make window not resizable
Python
0 vote175 views1 answer
Bassie en adriaan
Python