Use content of 2 lists and combine (stringified) values on same index into a third list

Question

Which method should i use to concate two dataframes in Pandas like:

before: dataframes1 =[1,2,3,4,5,6] dataframes2 =['a','b','c','d','e','f']
after: ['1a','2b','3c','4d','5e','6f']

Answer 1

You can use a for loop to traverse both lists and concatenate the results in a new list:

dataframes1 =[1,2,3,4,5,6] 
dataframes2 =['a','b','c','d','e','f']

result = []
for i in range(len(dataframes1)):
    result.append(str(dataframes1[i])+dataframes2[i])
print(result)

- Also you can simplify the syntax of the loop by invoking it in the list initialization:

dataframes1 =[1,2,3,4,5,6] 
dataframes2 =['a','b','c','d','e','f']

result = [str(dataframes1[i])+dataframes2[i] for i in range(len(dataframes1))]
print(result)

- Or use the zip() function to make the syntax clearer, as @patrick-artner suggested:

dataframes1 =[1,2,3,4,5,6] 
dataframes2 =['a','b','c','d','e','f']

result = [str(a)+b for a,b in zip(dataframes1, dataframes2)]
print(result)

Output:

['1a', '2b', '3c', '4d', '5e', '6f']

Answer 2

If both columns are strings, you can concatenate them;

import pandas as pd
df = pd.DataFrame()
df["result"] = dataframes1["column1"] + dataframes2["column1"]

If this is not enough ; please elaborate your question