Hello everyone, I’d just spent 5 hours on a simple issue with joining two dataframes. I’ve basically two dataframes, one with a column of sectors and value, the other with new sectors mapped to the previous one as well as weights associated. My issue is that I can’t perform leftjoin on the column…

you need to convert these columns to Vector because you have duplicates.

DataFrame: Cannot have duplicated names for indices

mbauman Split this topic March 29, 2022, 2:48pm 8

Topic		Replies	Views
Query.@join with repeated names Data query	1	713	April 24, 2019
DataFrame: New columns with names from existing column General Usage question , dataframes	1	294	August 10, 2023
SQLite: query with duplicate column names \|> DataFrame Data dataframes , sqlite	15	5264	March 29, 2022
Leftjoin with replacement Data dataframes	3	331	July 23, 2022
DataFrame join rename multiple columns in join command General Usage dataframes	1	622	February 1, 2022