python: DataFrame.append does not append element

Question

I am working one week with python and I need some help. I want that if certain condition is fulfilled, it adds a value to a database. My program doesn't give an error but it doesn't append an element to my database

import pandas as pd
noTEU = pd.DataFrame() # empty database
index_TEU = 0
for vessel in list:
    if condition is fullfilled:
        imo_vessel = pd.DataFrame({'imo': vessel}, index=[index_TEU])   
        noTEU.append(imo_vessel) # I want here to add an element to my database
        index_TEU = index_TEU + 1

If I run this, at the end I still get an empty dataframe. I have no idea why it doesn't do what I want it to do

It is not an inplace operation. Try noTEU = noTEU.append(imo_vessel) — user2285236
– user2285236, Commented Sep 16, 2016 at 15:58
Do we have a canonical question for this? Not specific to append but in general, for methods returning a new dataframe? — user2285236
– user2285236, Commented Sep 16, 2016 at 15:59
@ayhan there are a ton of questions with the same answer but there isn't a canonical one, it should be created as it gets tiresome explaining this — EdChum
– EdChum, Commented Sep 16, 2016 at 16:00
There's a similar one asked over here: stackoverflow.com/questions/16597265/… — Nickil Maveli
– Nickil Maveli, Commented Sep 16, 2016 at 16:02
@ayhan: Totally agree with that. Even the docs don't indicate whether append operation takes place inplace or not. — Nickil Maveli
– Nickil Maveli, Commented Sep 16, 2016 at 16:12

Fabio Lamanna · Accepted Answer · 2016-09-16 15:59:04Z

1

You should reassign the dataframe such as:

import pandas as pd
noTEU = pd.DataFrame() # empty database
index_TEU = 0
for vessel in list:
    if condition is fullfilled:
        imo_vessel = pd.DataFrame({'imo': vessel}, index=[index_TEU])   
        noTEU = noTEU.append(imo_vessel) # I want here to add an element to my database
        index_TEU = index_TEU + 1

and don't use the keyword list for a List because it's included in the Python syntax.

answered Sep 16, 2016 at 15:59

Fabio Lamanna

21.7k24 gold badges95 silver badges126 bronze badges

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

Collectives™ on Stack Overflow

python: DataFrame.append does not append element

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related