Please find a method to add one line to the Pandas.DataFrame

You want to create an empty DataFrame and write a code that adds one line at a time. Creating DataFrame succeeded, but when you try to add a row, an error occurs on the string side.

How can I put different types together in one line?

res = DataFrame (columns=('lib', 'qty1', 'qty2') #Successful

res = res.set_value(len(res), 'qty1', 10.0)

python pandas

2022-09-21 16:09

1 Answers

You can use loc to assign.

from pandas import DataFrame
from random import randint


res = DataFrame(columns=('lib', 'qty1', 'qty2'))
for i in range(5):
    res.loc[i] = [randint(-1,1) for n in range(3)]

print(res)

Output:

   lib  qty1  qty2
0   -1     1     0
1    1     0    -1
2    1     1     1
3    1     0     1
4    0     0    -1

2022-09-21 16:09

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656