I have a dataset that describes the sellers who are selling various brands. I need to identify the source (where did he buy those brands he is selling from) of those sellers. (Dimension of dataset 11,29,490 rows and 2 columns: Seller and brand)
I need unique instances for each seller. That is, in each row, I have to have a seller and all the information about the brands he is selling. My idea was to create make each unique brand as a feature and create a sparse dataset. However, we have almost 2 million unique brands. Is it possible to do some text classification and come up with some text clusters and then make each cluster as a feature? I am not sure if this is a correct approach I am stuck without an approach now. Can anyone help me with how should I approach this problem?
Thanks in advance