Trying to add looped string to empty dataframe pandas

Question

I am trying to generate links using a for loop and trying to add them to my empty dataframe like the example below:

linkdf = pd.DataFrame(columns=['Link'])


for i in range(1,10):
  l = 'https://google.com/assets/' + str(i)
  linkdf = linkdf.append(l)

but I am getting errors like below:

TypeError: cannot concatenate object of type '<class 'str'>'; only Series and DataFrame objs are valid

is there a way to add this to the empty dataframe with header already provided.

want result like below:

        Link
0.  https://google.com/assets/1
1   https://google.com/assets/2
2.  https://google.com/assets/3

Appreciate any help Thanks

Replace your append statement by : linkdf.loc[len(linkdf)] = [l] — Odhian
– Odhian, Commented Sep 20, 2021 at 10:13

jezrael · Accepted Answer · 2021-09-20 10:22:32Z

1

First create list and then pass to DataFrame like:

L = ['https://google.com/assets/' + str(i) for i in range(1,10)]
linkdf = pd.DataFrame(L,  columns=['Link'])

Your solution:

L = []
for i in range(1,10):
  l = 'https://google.com/assets/' + str(i)
  L.append(l)


print (L)
['https://google.com/assets/1', 'https://google.com/assets/2', 
 'https://google.com/assets/3', 'https://google.com/assets/4',  
 'https://google.com/assets/5', 'https://google.com/assets/6', 
 'https://google.com/assets/7', 'https://google.com/assets/8', 
 'https://google.com/assets/9']

linkdf = pd.DataFrame(L,  columns=['Link'])
print (linkdf)
                          Link
0  https://google.com/assets/1
1  https://google.com/assets/2
2  https://google.com/assets/3
3  https://google.com/assets/4
4  https://google.com/assets/5
5  https://google.com/assets/6
6  https://google.com/assets/7
7  https://google.com/assets/8
8  https://google.com/assets/9

If really need add data to empty DataFrame (it is slow):

linkdf = pd.DataFrame(columns=['Link'])

for i in range(1,10):
  l = 'https://google.com/assets/' + str(i)
  linkdf = linkdf.append({'Link':l}, ignore_index=True)

edited Sep 20, 2021 at 10:22

answered Sep 20, 2021 at 10:13

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

3 Comments

Zac Over a year ago

hi jezrael thank you for getting back i want to use your second solution but got this error"TypeError: append() takes no keyword arguments"

jezrael Over a year ago

@Zac - There is used L.append(l) instead linkdf = linkdf.append ?

jezrael Over a year ago

@Zac - What is print (L) ? It is list?

U13-Forward · Accepted Answer · 2021-09-20 10:16:57Z

1

Or why not just np.char.add:

linkdf['Link'] = np.char.add('https://google.com/assets/', np.arange(1, 10).astype(str))

>>> linkdf
                          Link
0  https://google.com/assets/1
1  https://google.com/assets/2
2  https://google.com/assets/3
3  https://google.com/assets/4
4  https://google.com/assets/5
5  https://google.com/assets/6
6  https://google.com/assets/7
7  https://google.com/assets/8
8  https://google.com/assets/9
>>>

answered Sep 20, 2021 at 10:16

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

3 Comments

Zac Over a year ago

sorry u12-forward this might not be the solution i am looking for but thank you for giving time

U13-Forward Over a year ago

@Zac Hmmm, why?

Zac Over a year ago

this is small part issue of my large code and changing it with your solution will have to change my whole code thank you again.

Collectives™ on Stack Overflow

Trying to add looped string to empty dataframe pandas

2 Answers 2

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related