Add column in dataframe from make list

Question

a*.csv

 D        A     B     E       F

park    KOREA   1   SUM1    hello1

michel  France  3   SUM3    hello3

park2   USA     4   SUM4    hello4

b*.csv

A       B   C

KOREA   1   2020

KOREA   2   177

France  3   2020

USA     4   43

SPAIN   7   67

example

 D        A     B    C(add)  E        F

park    KOREA   1   2020    SUM1    hello1

michel  France  3   2020    SUM3    hello3

park2   USA     4   3       SUM4    hello4

park3   SPAIN   7   67      SUM5    hello5

park4   USA     8   177     SUM6    hello6

park5   KOREA   11  584     SUM7    hello7

park6   DEN     5   43      SUM8    hello8

I edited the content and then restored it because the answer didn't solve it and I solved it myself

I'll end the question after commenting it solution

but I chose one answer to close this question

Hi, and welcome to Stack Overflow. This is a Q&A site, not a forum. If you solved your own question - great! but don't edit it to say "solved"; either close it (by accepting another answer, by answering your own question, or just by closing it) - or if the question is not interesting, delete it. — Itamar Mushkin
– Itamar Mushkin, Commented May 21, 2020 at 11:40
@Itamar Mushkin Thank you for explain about Stack Overflow, I will tried just by closing and delete it but I can't it's possible?? — Kim
– Kim, Commented May 21, 2020 at 13:02

score 1 · Accepted Answer · 2020-05-21 11:22:32Z

1

I think you can use the merge() function.

try_a = glob.glob('a*.csv')
try_b = glob.glob('b*.csv')
lst_a = []
lst_b = []
for (i,j) in zip(try_a,try_b):
 lst_a.append(i)
 lst_b.append(j)
df_a = pd.concat(lst_a)
df_b = pd.concat(lst_b)
df_a.set_index('d', inplace= True)
df = pd.DataFrame.merge(df_a,df_b, how = 'inner', left_index = True).reset_index()

I hope it works!!

edited May 21, 2020 at 11:22

answered May 21, 2020 at 5:55

user13233820

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

1 Comment

Kim Over a year ago

It's have a error messages -> Exception has occurred: AttributeError 'list' object has no attribute 'set_index'

Collectives™ on Stack Overflow

Add column in dataframe from make list

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related