Generating dataframe from Counter object

Question

I'm trying to visualize the correlation between POS values. From the list below I want to generate a dataframe where columns are equal to keys and the first row is equal to values.

I need this, to, after, plot df.corr()

Here are the variables:

keys = Counter(list_tag).keys()
keys

dict_keys(['NNP', 'VBZ', 'DT', 'NN', '.', 'PRP', 'VBD', 'IN', 'JJ', 'NNS', ',', '``', 'NNPS', "''", 'PRP$', 'CD', 'VB', 'TO', 'POS', 'RB', 'RBR', 'WP', 'MD', 'VBP', 'CC', 'WRB', 'WDT', 'RP', ':', 'VBN', 'VBG', 'EX', '(', 'JJR', ')', 'PDT', 'FW', 'RBS', 'JJS', 'UH'])

values = Counter(list_tag).values()
values

dict_values dict_values([282, 110, 259, 426, 106, 132, 60, 275, 204, 98, 119, 12, 3, 11, 41, 24, 80, 46, 25, 177, 7, 14, 30, 64, 112, 13, 10, 10, 21, 45, 42, 11, 12, 8, 12, 1, 1, 1, 2, 4])

My trouble is this: calling df = pd.DataFrame(Counter(list_tag), index=Counter(list_tag).keys()) As shown below, I'm writing something wrong because I need only the first row.

Is there an efficient solution to accomplish this without manual dropping of df.iloc[2:] Thank you!

I think you are missing a .values. It should be like pd.DataFrame(Counter(list_tag).values(), index=Counter(list_tag).keys()). Also you could save Counter(list_tag) to a variable — Dani Mesejo
– Dani Mesejo, Commented Oct 26, 2021 at 16:35

Mortz · Accepted Answer · 2021-10-26 16:39:07Z

1

keys = ['NNP', 'VBZ', 'DT', 'NN', '.', 'PRP', 'VBD', 'IN', 'JJ', 'NNS', ',', '``', 'NNPS', "''", 'PRP$', 'CD', 'VB', 'TO', 'POS', 'RB', 'RBR', 'WP', 'MD', 'VBP', 'CC', 'WRB', 'WDT', 'RP', ':', 'VBN', 'VBG', 'EX', '(', 'JJR', ')', 'PDT', 'FW', 'RBS', 'JJS', 'UH']
values = [282, 110, 259, 426, 106, 132, 60, 275, 204, 98, 119, 12, 3, 11, 41, 24, 80, 46, 25, 177, 7, 14, 30, 64, 112, 13, 10, 10, 21, 45, 42, 11, 12, 8, 12, 1, 1, 1, 2, 4]

df = pd.DataFrame(values, index=keys).transpose()

answered Oct 26, 2021 at 16:39

Mortz

4,9591 gold badge23 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Generating dataframe from Counter object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related