Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ENERGY-EU-TECHNOLOGY-1 #7

Open
igrypari opened this issue Mar 9, 2023 · 9 comments
Open

ENERGY-EU-TECHNOLOGY-1 #7

igrypari opened this issue Mar 9, 2023 · 9 comments
Assignees
Labels
Energy-EU-Technology-1 report-request Requests to create/edit reports and charts.

Comments

@igrypari
Copy link
Collaborator

igrypari commented Mar 9, 2023

I would like to request additions to the Energy-EU report, in the tab “Technology”.

The user flow that leads to the report is the following:

  • Browse topics for Climate > EU > select category "Energy" > Overview

Tab Name: Technology

Number Indicators
Patents (total number of publications using I09)
Average forward citations (average number using I12)

Chart Group 1: Technological Production Trends

    Chart 1:
        Title: Patents in Energy over time
        Description: The graph shows the evolution in the number of in the Energy domain granted by the EPO and still valid in 2021-Q2 by priority year. _Data Source:_ [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html 
        Type: area chart 
        Note: Indicator I09 
        xAxisName: year (2000 to most recent available)
        yAxisName: patents
        xColumnField: key
        yColumnField: value
        GroupingByField: --



       Chart 2:
       Title: Share of patents in Energy topics over time
        Description: The graph shows the evolution in the share of patents in different topics in the Energy domain, granted by the EPO and still valid in 2021-Q2. The ontology of topics is taken from the technical annex of the Final Report of the [EU taxonomy for sustainable activities](https://finance.ec.europa.eu/sustainable-finance/tools-and-standards/eu-taxonomy-sustainable-activities_en#documents) (Chapter 4. “Electricity, gas, steam and air conditioning supply,” p. 205). We assigned patents to  topics, by matching topics to CPC codes. _Data Source:_ [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
       Note: Indicator I09B, SV01 (please make sure the topics are visible in the legend, also the pop-up when hovering is not readable)
        Type: stacked area chart
        xAxisName: year (2000 to most recent available)
        yAxisName: patents
        xColumnField: key
        yColumnField: value
        GroupingByField: topic

Chart Group 2: Technological Production Origins

    Chart 1:
        Title: Patents by country
        Description: The graph shows the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2 by the country of the applicant . _Data Source:_ [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
       Note: Indicator I09, SV09
        Type: world map
        xAxisName: 
        yAxisName: 
        xColumnField: key
        yColumnField: value
        GroupingByField:_ 

Chart 2:
Title: Patents by Organization (top 100)
Description: The graph shows the top 100 organizations of patent applicants in terms of the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2.
Type: column with the ability to move the x-axis range (like in data4impact societal impact tab) and filter for organization name. Initialize at top 20)
NOTE: indicator I09 – SV06
xAxisName: organization
yAxisName: patents
xColumnField: key
yColumnField: value
GroupingByField:

Chart 3:
Title: Patents by sector
Description: The graph shows the number of patents in the Energy domain granted by the EPO and currently valid (at least until 2021 Q2) by the type of patent applicant. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
Note: Indicator I09, SV08
Type: doughnut chart (https://echarts.apache.org/examples/en/editor.html?c=pie-doughnut)
xAxisName:
yAxisName:
xColumnField: key
yColumnField: value
GroupingByField:_


Chart Group 3: Technological Production Characteristics

Chart 1:
Title: Patents by NACE code
Description: The graph shows the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2 by the NACE (Nomenclature of Economic Activities) codes of patents as assigned by PATSTAT. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
NOTE: Indicator – I09, SV07
Type: https://echarts.apache.org/examples/en/editor.html?c=pie-legend
xAxisName:
yAxisName:
xColumnField: key
yColumnField: value
GroupingByField:

Chart 2:
Title: Patents by IPC code (top 20 codes)
Description: The graph shows the top 20 IPC (International Patent Classification) codes by the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2 by IPC. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
NOTE: Indicator – I09, SV13
Type: horizontal bar chart
xAxisName:
yAxisName:
xColumnField: key
yColumnField: value
GroupingByField:

Chart 3:
Title: Patents by topic
Description: The graph shows the number of patents by topic in the Energy domain, granted by the EPO and still valid in 2021-Q2. The ontology of topics is taken from the technical annex of the Final Report of the EU taxonomy for sustainable activities (Chapter 4. “Electricity, gas, steam and air conditioning supply,” p. 205). We assigned patents to topics, by matching topics to CPC codes. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
NOTE: Indicator – I09, SV02
Type: Type: ordered nightingale chart with the legend (https://echarts.apache.org/examples/en/editor.html?c=pie-roseType-simple but legend on side)
xAxisName:
yAxisName:
xColumnField: key
yColumnField: value
GroupingByField:

Chart Group 4: Technological Impact Trends

Chart 1:
Title: Technological value of patents over time
Description: The graph shows the evolution in the type of patents in the Energy domain granted by the EPO and still valid in 2021-Q2 by priority year. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where the low is defined as below average, and high as above average. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
Type: https://echarts.apache.org/examples/en/editor.html?c=radar2
Note: Indicator I12A – SV01
xAxisName: (end points) class of patents (adopters, enablers, pioneers, mavericks)
yAxisName: patents
xColumnField: key
yColumnField: value
GroupingByField: year

Chart 2:
Title: Patent citations over time
Chart Subtitle:
Description: The graph shows the average number of backward and forward citations to other patents for patents in the Energy domain, granted by the EPO and still valid in 2021-Q2. _ Data Source:_ Patstat - EPO dataset.
Note: Indicator I11 SV01 (average backward citations), I12 SV02 (average forward citations)
Type: two basic line chart with legend
xAxisName: year (2000 to most recent available)
yAxisName: average citations
xColumnField: key
yColumnField: value
GroupingByField:


Chart Group 5: Technological Impact Origins
Title: Patents by country and technological value
Description The graph shows the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2 by the country of the applicant, for different types of patent. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where the low is defined as below average, and high as above average. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
Note: Indicator I12A, SV09
Type: world map with choice of which of the four classes to view the map for (initiate at pioneers)
xAxisName:
yAxisName:
xColumnField: key
yColumnField: value
GroupingByField:_
Filter: type of patent (adopters, enablers, pioneers, mavericks)

Chart 2:
Title: Patents by Organization (top 100) and technological value
Description: The graph shows the top 100 organizations of patent applicants in terms of the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2, for different types of patents. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where the low is defined as below average, and high as above average. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
Type: column graph with x-axis range option (initiate at top 20) with choice of which of the four classes to view the graph for (initiate at pioneers)
NOTE: indicator I12A – SV06
xAxisName: organization
yAxisName: patents
xColumnField: key
yColumnField: value
GroupingByField:
Filter: type of patent (adopters, enablers, pioneers, mavericks)

Chart 3:
Title: Patents by sector and technological value
Description: The graph shows the number of patents in the Energy domain granted by the EPO and currently valid (at least until 2021 Q2) by the type of patent applicant, for different types of patents. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where the low is defined as below average, and high as above average. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
Note: Indicator I12A, SV08
Type: doughnut chart (https://echarts.apache.org/examples/en/editor.html?c=pie-doughnut) with choice of which of the four classes to view the graph for (initiate at pioneers)
xAxisName:
yAxisName:
xColumnField: key
yColumnField: value
GroupingByField:_
Filter: type of patent (adopters, enablers, pioneers, mavericks)


Chart Group 6: Technological Impact Characteristics

Chart 1:
Title: Patents by NACE code and by technological value
Description: The graph shows the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2 by the NACE (Nomenclature of Economic Activities) codes of patents as assigned by PATSTAT, for different types of patents. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where the low is defined as below average, and high as above average. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
NOTE: Indicator – I12A, SV07 with choice of which of the four classes to view the graph for (initiate at pioneers)
Type: https://echarts.apache.org/examples/en/editor.html?c=pie-legend
xAxisName:
yAxisName:
xColumnField: key
yColumnField: value
GroupingByField:
Filter: type of patent (adopters, enablers, pioneers, mavericks)

Chart 2:
Title: Patents by IPC code (top 20 codes) and by technological value
Description: The graph shows the top 20 IPC (International Patent Classification) codes by the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2 by IPC, for different types of patents. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where the low is defined as below average, and high as above average. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
NOTE: Indicator – I12A, SV13 with choice of which of the four classes to view the graph for (initiate at pioneers)
Type: horizontal bar chart
xAxisName:
yAxisName:
xColumnField: key
yColumnField: value
GroupingByField:
Filter: type of patent (adopters, enablers, pioneers, mavericks)

Chart 3:
Title: Patents by topic
Description: The graph shows the number of patents by topic in the Energy domain, granted by the EPO and still valid in 2021-Q2, for different types of patents. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where the low is defined as below average, and high as above average. The ontology of topics is taken from the technical annex of the Final Report of the EU taxonomy for sustainable activities (Chapter 4. “Electricity, gas, steam and air conditioning supply,” p. 205). We assigned patents to topics, by matching topics to CPC codes. Data Source: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html
NOTE: Indicator – I12A, SV02 with choice of which of the four classes to view the graph for (initiate at pioneers)

        Type: Type: ordered nightingale chart with the legend (https://echarts.apache.org/examples/en/editor.html?c=pie-roseType-simple but legend on side) 
        xAxisName: 
        yAxisName: 
        xColumnField: key
        yColumnField: value
        GroupingByField: 
   Filter: type of patent (adopters, enablers, pioneers, mavericks)
@igrypari igrypari added report-request Requests to create/edit reports and charts. Energy-EU-Technology-1 labels Mar 9, 2023
@igrypari
Copy link
Collaborator Author

igrypari commented May 23, 2023

@dtziotzios

I note the following errors on the report, as I see it in BSC today. Please indicate which ones of them are due to data issues.

a. The number indicators requested at the beginning of the report are not shown.

b. Chart Group 1, chart 2: The legend on the side is not visible, and when hovering the legend covers the entire chart making it un-usable. Legend in the bottom and when hovering only show the category you're hovering over?

c. Chart Group 2, chart 3: there is a big chunk of data with an empty label

d. Chart Group 3, chart 3: legend and labels not visible

e. Chart Group 4, chart 1: please make it so that the ombre effect created is consistent over time, so that 2021 is darker than 2020 is darker than 2019 etc.. Right now it gets darker till 2013 and then lighter again.

f. Chart Group 5, chart 2 "no data"

g. Chart Group 5, chart 3 legend, labels and filter choice not legible

@dtziotzios
Copy link
Collaborator

dtziotzios commented Jun 1, 2023

Some updates regarding @igrypari notes. Please keep in mind that the following changes will be available after the next BSC installation update. I'll inform you here after the update.

a. We are looking into it.
b. Fixed using the echarts legend functionality to wrap the text.
c. This is an issue with the data. Some names are empty text. We are getting data from pv01 i09 sv08.
d. Fixed using the echarts legend functionality to wrap the text.
e. We are looking into it.
f. Maybe you mean Chart group 6 - chart 2? If yes, then data are missing. We were looking for i12a sv13.
g. We are looking into it.

@dtziotzios
Copy link
Collaborator

@gkountouris please also provide the SVXX for the Number Indicators.

@dtziotzios
Copy link
Collaborator

All the above issues are resolved with the new data provided.

@gkountouris
Copy link
Collaborator

Groupchart 2 chart 2 Probably has a mistake. The data I have given seems to be ok.
Groupchart 5 chart 2 Also has the same mistake.
Groupchart 5 chart 1 funny number with Mali having the highest average of citations per publication.

@dtziotzios @igrypari

@dtziotzios
Copy link
Collaborator

@gkountouris
for Groupchart 2 chart 2 the data from pv01 - i09 - sv06 grouped by key are used, as described by Ioanna above.
for Groupchart 5 chart 2 the data from pv01 - i12a - sv06 grouped by key and filtered by tag are used, as described by Ioanna above.
for Groupchart 5 chart 1 the data from pv01 - i12a - sv09 grouped by metric_scope and filtered by key are used, as described by Ioanna above.

Are these the correct data?

@gkountouris
Copy link
Collaborator

@dtziotzios

Yes those are the correct data.

@igrypari
Copy link
Collaborator Author

igrypari commented Sep 29, 2023

Hello here are some issues I found, please excuse me if they are mentioned in the open tickets above.

https://sti-viewer.intelcomp.bsc.es/indicator-report/dashboard?params=%7B%22keywordFilters%22:%5B%7B%22field%22:%22domain%22,%22values%22:%5B%22Climate%22%5D%7D,%7B%22field%22:%22country%22,%22values%22:%5B%22EU%22%5D%7D,%7B%22field%22:%22pv%22,%22values%22:%5B%22Energy%22%5D%7D%5D,%22displayName%22:%22Energy%20-%20EU%22,%22dashboard%22:%22dg01_pv01_dashboard%22%7D

Climate --> EU --> Energy --> technology

  1. @gkountouris Number indicator: Average forward citations - the number is wrong. This is supposed to be the average number of forward citations per patent.

  2. @dtziotzios @GeorgeEnglezosCite technological production trends, share of patents in energy topics over time: when hovering i would like to see the label of only ONE line, otherwise illegible

  3. @dtziotzios @GeorgeEnglezosCite technological production characteristics, patents by Nace code. Unfortunately this visualisation doesn't handle the type of data we have nicely, can we please try a radial polar bar (with multiple colors) or a bar chart (with multiple colors) both ranked by number of patents, and with ability to zoom is/select the range in the axis?

  4. @dtziotzios @GeorgeEnglezosCite technological production characteristics, patents by IPC code.

  • I cannot read the entire text on the y axis.
  • the x axis says "citations per publication" it should say "number of patents"
  • the y axis says "organisation" it should say "IPC code"
  • when hovering on the top bars the label goes to the left and out of the screen, illegible
  • I prefer if it was multiple colors
  1. @dtziotzios @GeorgeEnglezosCite technological impact trends, technological value of patents over time the description has an extra "the" /// it says "where the low is defined as" - please make it "where low is defined as" ---- IF you can please do this change in all of the following charts, the same mistake is carried through, big thanks

  2. @dtziotzios @GeorgeEnglezosCite technological impact origins, patents by country and technological value, please switch description to" Description/Source: The graph shows the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2 by the country of the applicant, for different types of patent. Use the filter on the top right to switch between different types. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where the low is defined as below average, and high as above average. Data Source: Patstat - EPO dataset

  3. @dtziotzios @GeorgeEnglezosCite Technological Impact Origins, patents by organisation (top 100) and technological value - please change description to:
    The graph shows the top 100 organizations of patent applicants in terms of the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2, for different types of patents. Use the filter on the top right to switch between different types. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where the low is defined as below average, and high as above average. Data Source: Patstat - EPO dataset

  4. @dtziotzios @GeorgeEnglezosCite technological impact origins, patents by sector and technological value,

  • please switch description to:

"The graph shows the number of patents in the Energy domain granted by the EPO and currently valid (at least until 2021 Q2) by the type of patent applicant, for different types of patents. Use the filter on the top right to switch between different types. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where the low is defined as below average, and high as above average. Data Source: Patstat - EPO dataset"

  • it would be useful if the different sectors had the same colors when filtering (as opposed to being chosen automatically) that way "company" for example would always be blue.
  1. @dtziotzios @GeorgeEnglezosCite technological impact characteristics, patents by nace code and by technological value
  • change description to "The graph shows the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2 by the NACE (Nomenclature of Economic Activities) codes of patents as assigned by PATSTAT, for different types of patents. Use the filter on the top right to switch between different types. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where the low is defined as below average, and high as above average. Data Source: Patstat - EPO dataset ."

  • ideally change chart type as number 3 above. IF NOT then see these comments:

  • the colors repeat and you have two blues next to each other // can we have non-repeating colors? (wherever this visualisation is used?)

  • the labels and the title are kind of on top of each other

  • the labels on the right side are hidden by the legend and are not legible.

  1. @gkountouris technological impact characteristics, patents by nace code and by technological value - i am surprised that there are so few NACE codes when at the chart further up "technological production characteristics, patents by NACE code" there were so many different ones - can you double check the data?

  2. @dtziotzios @GeorgeEnglezosCite technological impact characteristics, patents by IPC code (top 20 codes) and by technological value

  • please change description to "Description/Source: The graph shows the top 20 IPC (International Patent Classification) codes by the number of patents in the Energy domain granted by the EPO and still valid in 2021-Q2 by IPC, for different types of patents.** Use the filter on the top right to switch between different types.** There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where the low is defined as below average, and high as above average. Data Source: Patstat - EPO dataset"

  • If you can use multiple colors like in AI-SCIENCE-1 #4 above.

  • y label says organisation instead of "IPC code"

  • i cannot read the y axis labels

  1. @dtziotzios @GeorgeEnglezosCite technological impact characteristics, patents by topic
  • the title should be "Patents by topic and by technological value"
  • the legend is hiding the labels on the right
  • hovering over the filter, "open filters" falls on the legend and is not legible.
  • change description to "The graph shows the number of patents by topic in the Energy domain, granted by the EPO and still valid in 2021-Q2, for different types of patents. Use the filter on the top right to switch between different types. There are four types of patents based on the average number of backward citations (BC) and forward citations (FC) to other patents. Adopters (low FC, high BC), enablers (high FC, high BC), pioneers (high FC, low BC) and mavericks (low FC, low BC), where the low is defined as below average, and high as above average. The ontology of topics is taken from the technical annex of the Final Report of the EU taxonomy for sustainable activities (Chapter 4. “Electricity, gas, steam and air conditioning supply,” p. 205). We assigned patents to topics, by matching topics to CPC codes. Data Source: Patstat - EPO dataset"

@dtziotzios
Copy link
Collaborator

Requested changes are deployed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Energy-EU-Technology-1 report-request Requests to create/edit reports and charts.
Projects
None yet
Development

No branches or pull requests

3 participants