/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

8 votes172 views3 answers
Can't find model 'en_core_web_sm'
Python
2 votes196 views2 answers
Np logical not
Python
0 vote158 views1 answer
Download face_cascade.detectMultiScale
Python
25 votes177 views3 answers
Startapp django
Python
0 vote171 views1 answer
Python durchschnitt liste
Python
0 vote169 views1 answer
Django amzon like app
Python
33 votes177 views4 answers
Change dataframe column type
Python
0 vote178 views1 answer
ModuleNotFoundError: No module named 'pyvis'
Python
0 vote258 views1 answer
Python NameError: name 'io' is not defined
Python
21 votes157 views6 answers
Python list directories only
Python