Problem with appending values into a empty dataframe

Question

frame = pd.DataFrame()
for i in range (1995,2020):
  file_name = f"{i}"
  df = pd.read_csv(BytesIO(uploaded["%s.csv"%file_name]))
  df = pd.DataFrame(data, columns= ['DATE','ARANGALI'])
  frame.append(df)
print(frame)

I tried to define a function to append all the the data I have into one dataframe. The output appears to be an empty dataframe.

Empty DataFrame; Columns: []; Index: [].

The code works if consider the variables frame and df as lists and appends up to a large list. But I want a dataframe with all the data under the same column heads. What am I doing wrong?

Alex · Accepted Answer · 2021-03-17 12:06:56Z

1

Append method returns a new DataFrame. Docs.

frame = pd.DataFrame()
for i in range (1995,2020):
  file_name = f"{i}"
  df = pd.read_csv(BytesIO(uploaded["%s.csv"%file_name]))
  df = pd.DataFrame(data, columns= ['DATE','ARANGALI'])
  frame = frame.append(df)
print(frame)

answered Mar 17, 2021 at 12:06

Alex

7411 gold badge6 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Problem with appending values into a empty dataframe

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related