Ask Your Question

Group CSV Data and get a graph

asked 2018-05-16 22:41:11 +0200

Hello there, at first sorry for my english, as i am no native speaker ;) My problem is the following: I got a Python script which logs data from the NYTimes API. The CSV Sheet containts three different columns: Year, Country, Numbers of Articles, so the data looks like: image description

What i am planning now is to picture that data as a graph. Therefore i would like to group or rather rearrange the data by using calc. In the end i should get the different years in the first column , and the different countrys in the first row so that it looks like : image description

How may i do this?

Thank you very much for your support :)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-05-17 02:26:15 +0200

m.a.riosv gravatar image

Menu/Insert/Pivot table is what you are looking for. And even more if you are using LibreOffice 6 creating a chart while in the pivot table, creates a chart linked to it.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-16 22:41:11 +0200

Seen: 31 times

Last updated: May 17