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.

you could add ;makeunique=true to the join call and see which columns clash

Unfortunately it can’t help, I still have the same issue using makeunique = true. Indeed, this could help if the issue was about column names, but it isn’t. It seems that duplicated keys for merging aren’t allowed. I can see it by using leftjoin(df, df_2, on = :sector, validate = (true, true)) w…

Can you please show a full stack trace. This is an error not in DataFrames.jl, but in the package that provides vectors for your columns. Most likely some of your columns come from https://github.com/davidavdav/NamedArrays.jl and this causes an error (such columns do not allow for duplicate rows).

You’re right! Some of my columns come from a NamedArray initially. Here is indeed a MWE giving the error message I have: using DataFrames using NamedArrays initial = NamedArray([5748.61], ["AUT-A01"]) df_initial = DataFrame(:sector => names(initial,1), :value => initial[:,1]) df_weights = DataFr…

Thank you so much! For those wondering, this is the solution with the MWE thanks to @bkamins : using DataFrames using NamedArrays initial = NamedArray([5748.61], ["AUT-A01"]) df_initial = DataFrame(:sector => vec(names(initial,1)), :value => vec(initial[:,1])) df_weights = DataFrame(sector = ["AU…

DataFrame: Cannot have duplicated names for indices

General Usage

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

7 posts were split to a new topic: Column types in DataFrames vs. InMemoryDatasets

Topic		Replies	Views
Query.@join with repeated names Data query	1	734	April 24, 2019
Joining two dataframes of different size only when colum values are coincident New to Julia dataframes	2	370	February 1, 2023
How to merge 2 dataframes (DataFrames.jl) General Usage question , dataframes	5	5509	July 9, 2021
Unsure how to solve error message when applying unstack to DataFrame General Usage question , package , dataframes , unstack	6	3685	May 14, 2024
Using nonunique() with multiple dataframe columns General Usage question , dataframes	2	777	July 13, 2021

DataFrame: Cannot have duplicated names for indices

Related topics