/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

3 votes93 views1 answer
Centos v8.11.1 npm gyp err! stack error: can't find python executable "python", you can set the python env variable.
Python
0 vote134 views1 answer
How to add a file to an email in python
Python
0 vote137 views1 answer
Caqch làm app chatbot python
Python
4 votes142 views3 answers
Display prime numbers between two intervals in python
Python
5 votes143 views3 answers
Convert categorical column to int in pandas
Python
0 vote138 views1 answer
Round to nearest multiple of 5 python
Python
0 vote136 views1 answer
How append a directory based on current directory python
Python
2 votes145 views6 answers
How to download nltk in python
Python
7 votes137 views2 answers
How to generate requirements.txt django
Python
-2 votes155 views1 answer
Requests.exceptions.connectionerror: ('connection aborted.', remotedisconnected('remote end closed connection without response'))
Python