concatenation - Concatenating and adding prefix to columns

Question

I need to concatenate several dataframes for different cryptocurrencies. They all have exactly the same column names (you can see it on the screenshot with bitcoin and ethereum, but they are all like that). On the second screenshot you can see how I concatenated it, but it basically just added all rows to the same dataframe. However, it's not what I need. Could you guys tell me how I can concatenate all the datasets so the columns will be, for example 'Bitcoin_Date, Bitcoin_Open, Bitcoin_High... Ethereum_Date,Ethereum_Open, Ethereum_High' etc for all coins? So basically not just add all rows together, but create different columns for each of the tokens. What would be the best way to do it? Thanks!

Tokens separately Tokens concatenated

question from:https://stackoverflow.com/questions/65862443/concatenating-and-adding-prefix-to-columns

Answer 1

Waitting for answers