How to merge or concatenate two different datasets into one

Question

I have a list of strings with tickers

tickers = [AA, GME...]
It is just an example I have a variable with 50 tickers
50_tickers = [AA,GME,FB,MSFT...] 50 of them
And I need to combine all of them following the same pattern as below

AA dataset looks like this

2021:03:21 | 33.45
2021:03:22 | 33.50
2021:03:23 | 33.60
2021:03:24 | 33.70

GME dataset looks like this

2021:03:21 | 10.45
2021:03:22 | 11.50
2021:03:23 | 12.60
2021:03:24 | 12.65

I want to combine these two datasets to look like this

time | price AA | price GME
2021:03:21 | 33.45 | 10.45
2021:03:22 | 33.50 | 11.50
2021:03:23 | 33.60 | 12.60
2021:03:24 | 33.70 | 12.65

Here is what I have tried

for combine in tickers:
df = pd.DataFrame(combine)
df.concat(df[combine])

I know that it doesn't work. I don't know other methods to combine two datasets into one with common time column. I would appreciate your hint thank you

Does this answer your question? [Pandas Merging 101](https://stackoverflow.com/questions/53645882/pandas-merging-101) — Anurag Dabas, Jul 21 '21 at 16:15
Not really because I have a list of 50 strings and they are not separate variable and each of them carries separate information — YanRemes, Jul 21 '21 at 16:50

Tejas · Accepted Answer · 2021-07-21T16:27:16.057

1

You can do it like this

df=None
flag=False
for combine in tickers:
    if not Flag:
        df = pd.DataFrame(combine)
        flag=True
    else:
        df_t = pd.DataFrame(combine)
        df = df.merge(df_t, on='time')
df

edited Jul 21 '21 at 16:27

answered Jul 21 '21 at 16:10

Tejas

391
3
11

I don't have a variable name df_aa and df_gme – YanRemes Jul 21 '21 at 16:22
I just have a lis of strings – YanRemes Jul 21 '21 at 16:22
And can you suggest a way to do it with concat? – YanRemes Jul 21 '21 at 16:23
Sorry didn't mention that I have 50 tickers it is not just 2 of them – YanRemes Jul 21 '21 at 16:26
it works only with two tickers and not 50 – YanRemes Jul 22 '21 at 12:23
what is the issue with others? – Tejas Jul 22 '21 at 12:41
can you please explain what flag false does in this case? – YanRemes Jul 22 '21 at 14:33
Glad to hear that the solution helped, So flag is checking that if the loop is running for the first time, to use merge we need two dataset, but when first dataframe comes we do not have any to merge with it so we can use that flag to let know that this is first df and we should not merge with anything and once first iteration over it we are setting it true which will let us know that now we already have df and we can merge the incoming df to it – Tejas Jul 22 '21 at 15:03

How to merge or concatenate two different datasets into one

1 Answers1