Agrifood-EU-Industry-1

[igrypari]

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

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

Browse topics for Climate > EU > select category "Agrifood" > Overview

Tab Name: Industry

Number Indicators
Companies (number of companies in Agrifood in EU, I30AA)
Industry Publications (number of publications by companies in Agrifood in EU, I31A)
Industry Patents (number of patents by companies in Agrifood in EU, I32Α)
Industry Trademarks (number of trademarks by companies in Agrifood in EU, I33A)

Charts

Chart Group 1: Companies in Agrifood in EU

Chart 1:
Title: Top Companies by Revenue per Employee
Description: The graph showcases the leading Agrifood companies in the EU, ranked according to their revenue per employee. To compile this list, we selected companies from Orbis using Agrifood-related NACE (Nomenclature of Economic Activities) codes. We refined the dataset by employing text mining techniques on their webpages to identify key agrifood terms. To calculate the revenue per employee, we utilized Orbis data by dividing the turnover by the number of employees. Data Source: Orbis
Type: Horizontal Bar with ability to select range in y-axis, initialize at top 10 companies
Indicator: I30A, revenue per employee
xAxisName: revenue per employee
yAxisName: company name
xColumnField: key
yColumnField: value
GroupingByField:
Note: What is the max number of companies that we can show? Is it possible for the user to search for a specific company name? That would be great

Chart 2:
Title: Top Companies by Revenue per Employee and by NACE Code
Description: The graph illustrates the EU's top Agrifood companies filtered by NACE code, ranked by their revenue per employee. Use the filter on the top right to change the NACE code selection. To compile the list, we selected companies from Orbis using Agrifood-related NACE (Nomenclature of Economic Activities) codes. We refined the dataset by employing text mining techniques on their webpages to identify key agrifood terms. To calculate the revenue per employee, we utilized Orbis data by dividing the turnover by the number of employees. Data Source: Orbis
Type: Horizontal Bar with ability to select range in y-axis, initialize at top 10 companies
Indicator: I30A, revenue per employee
xAxisName: revenue per employee
yAxisName: company name
xColumnField: key
yColumnField: value
GroupingByField:
Filter: SV07 – preselect at the first value
Note: What is the max number of companies that we can show? Is it possible for the user to search for a specific company name? That would be great

Chart 3:
Title: Top Companies by Revenue per Employee and by Country
Description: The graph illustrates the top Agrifood companies filtered by EU country, ranked by their revenue per employee. Use the filter on the top right to change the country selection. To compile the list, we selected companies from Orbis using Agrifood-related NACE (Nomenclature of Economic Activities) codes. We refined the dataset by employing text mining techniques on their webpages to identify key agrifood terms. To calculate the revenue per employee, we utilized Orbis data by dividing the turnover by the number of employees. Data Source: Orbis

Type: Horizontal Bar with ability to select range in y-axis, initialize at top 10 companies
Indicator: I30A, revenue per employee
xAxisName: revenue per employee
yAxisName: company name
xColumnField: key
yColumnField: value
GroupingByField:
Filter: SV09 – preselect at the first value  filter must have the option to write the first few letters if many options
Note: What is the max number of companies that we can show? Is it possible for the user to search for a specific company name? That would be great

Chart Group 2: Company Distributions

Chart 1:
Title: Number of Companies by Country
Description: The graph shows the number of companies in Agrifood by EU country. We identified Agrifood companies using related NACE (Nomenclature of Economic Activities) codes, further refining the dataset by employing text mining techniques on company webpages to identify key agrifood terms. Data Source: Orbis
Type: World map (initialize zoomed in Europe) or Europe map
Indicator: I30AΑ, SV09
xAxisName: country
yAxisName: number of companies
xColumnField: key
yColumnField: value
GroupingByField:

Chart 2:
Title: Number of Companies by NACE
Description: The graph shows the number of companies in Agrifood by NACE (Nomenclature of Economic Activities) code. We identified Agrifood companies using related NACE codes, further refining the dataset by employing text mining techniques on company webpages to identify key agrifood terms. Data Source: Orbis
Type: https://echarts.apache.org/examples/en/editor.html?c=treemap-disk
Indicator: I30AΑ, SV07 and SV07b
xAxisName:
yAxisName:
xColumnField: key
yColumnField: value
GroupingByField:
Filter:
Note: The different colors are the NACE 2-digit codes (SV07a) and the boxes within those colors are the NACE 4-digit codes (SV07b). If this one is easier to show let’s do that: https://echarts.apache.org/examples/en/editor.html?c=treemap-show-parent

Chart Group 3: Company Innovativeness

Chart 1:
Title: Companies by Innovative Activity
Description: The graph displays different types of innovative activities carried out by EU Agrifood companies. Data Sources: OpenAIRE Graph, [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html, EUIPO, Orbis
Type: stacked radial polar bar, ranked by total (sum of stacks), initialize at top 20
Indicators: series 1 I31 publications, series 2 I32 patents, series 3 I33 trademarks
xAxisName: company
yAxisName: innovative activities
xColumnField: key
yColumnField: value
GroupingByField:
Filter:
Note: What is the max number of companies that we can show? Is it possible for the user to search for a specific company name? That would be great!

Chart 2:
Title: Companies by Innovative Activity and by NACE 2-digit code
Description: The graph displays different types of innovative activities carried out by EU Agrifood companies filtered by NACE (Nomenclature of Economic Activities) 2-digit code. Use the filter on the top right to change the NACE code selection. Data Sources: OpenAIRE Graph, [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html, EUIPO, Orbis
Type: stacked radial polar bar, ranked by total (sum of stacks), initialize at top 20
Indicators: series 1 I31 publications, series 2 I32 patents, series 3 I33 trademarks
xAxisName: company
yAxisName: innovative activities
xColumnField: key
yColumnField: value
GroupingByField:
Filter: NACE Code (SV07), initialize at first value
Note: This is the same as the previous chart but with a filter.

Chart 3:
Title: Companies by Innovative Activity and by NACE 4-digit code
Description: The graph displays different types of innovative activities carried out by EU Agrifood companies filtered by NACE (Nomenclature of Economic Activities) 4-digit code. Use the filter on the top right to change the NACE code selection. Data Sources: OpenAIRE Graph, [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html, EUIPO, Orbis

Type: stacked radial polar bar, ranked by total (sum of stacks), with interactive x-range, initiative at top 20
Indicators: series 1 I31 publications, series 2 I32 patents, series 3 I33 trademarks
xAxisName: company
yAxisName: innovative activities
xColumnField: key
yColumnField: value
GroupingByField:
Filter: NACE Code (SV07b), initialize at first value
Note: This is the same as the previous chart but with a different filter.

---

Chart Group 4: Industry Innovativeness - Publications

Chart 1:
Title: Industry Publications by Year and Topic
Description: The graph displays the yearly average number of publications per company, in Agrifood in the EU, by the year and topic of publication. The assignment of topics is taken from Abbate, Centobelli, Cerchione (2023) (https://doi.org/10.1016/j.techfore.2022.122222) which we enhanced and mapped to topics in our Fields of Science (FoS) publication classification system (http://doi.org/10.3389/frma.2023.1149834). Data Sources: OpenAIRE Graph, Orbis

Type: Stacked area graph (careful that legend is legible)
Indicators: i31AA SV02.01
xAxisName: year
yAxisName: average # publications per company
xColumnField: key
yColumnField: value
GroupingByField: topic
Filter: none
Note:

Chart 2:
Title: Industry Publications by SDG
Description: The graph displays the yearly average number of publications per company, in Agrifood in the EU, by SDG. Our SDG classification system uses deep learning techniques to assign a scientific publication to the SDGs that are related to it. Data Sources: OpenAIRE Graph, Orbis
Type: tree map with multiple colors (https://echarts.apache.org/examples/en/editor.html?c=treemap-disk) – please use SDG colors
Indicators: i31AA SV05
xAxisName: SDG
yAxisName: average # publications per company
xColumnField: key
yColumnField: value
GroupingByField:
Filter: none
Note:

Chart 3:
Title: Industry Publications by Company Size
Description: The graph displays yearly average number of publications per company, in Agrifood in the EU, by number of employees. Data Sources: OpenAIRE Graph, Orbis
Type: column
Indicators: i31AA SV15
xAxisName: number of employees
yAxisName: average # publications per company
xColumnField: key
yColumnField: value
GroupingByField:
Filter: none
Note:

Chart 4:
Title: Industry Publications by Country
Description: The graph displays yearly average number of publications per company, in Agrifood in the EU, by country. . Data Sources: OpenAIRE Graph, Orbis
Type: world map
Indicators: i31AA SV09
xAxisName: country
yAxisName: average # publication per company
xColumnField: key
yColumnField: value
GroupingByField:
Filter: none
Note:

Chart Group 5: Industry Innovativeness - Patents

Chart 1:
Title: Industry Patents by Year and Topic
Description: The graph displays the yearly average number of patents per company, in Agrifood in the EU, by the priority year and topic of patent. The topics are taken from Abbate, Centobelli, Cerchione (2023) (https://doi.org/10.1016/j.techfore.2022.122222) which we mapped to CPC codes. Data Sources: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html, Orbis

Type: Stacked area graph (careful that legend is legible)
Indicators: i32AA SV02.01
xAxisName: year
yAxisName: average # patents per company
xColumnField: key
yColumnField: value
GroupingByField: topic
Filter: none
Note:

Chart 2:
Title: Industry Patents by Company Size
Description: The graph displays the yearly average number of patents per company, in Agrifood in the EU, by number of employees. Data Sources: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html, Orbis
Type: column
Indicators: i32AA SV15
xAxisName: number of employees
yAxisName: average # patents per company
xColumnField: key
yColumnField: value
GroupingByField:
Filter: none
Note:

Chart 3:
Title: Industry Patents by country
Description: The graph displays the yearly average number of patents per company, in Agrifood in the EU, by country. Data Sources: [Patstat - EPO dataset](https://www.epo.org/searching-for-patents/business/patstat.html, Orbis
Type: world map
Indicators: i32AA SV09
xAxisName: country
yAxisName: average # publication per company
xColumnField: key
yColumnField: value
GroupingByField:
Filter: none
Note:

Chart Group 6: Industry Innovativeness - Trademarks

Chart 1:
Title: Industry Trademarks by Year
Description: The graph displays the yearly average number of trademarks per company, in Agrifood in the EU, by year. Data Sources: EUIPO, Orbis
Type: Stacked
Indicators: i33AA, SV01
xAxisName: year
yAxisName: average # trademarks per company
xColumnField: key
yColumnField: value
GroupingByField:
Filter: Non-expired (trademarks that haven’t expired)
Note:

Chart 2:
Title: Industry Trademarks by Type
Description: The graph displays the yearly average number of trademarks per company, in Agrifood in the EU, by trademark type. Data Sources: EUIPO, Orbis
Type: https://echarts.apache.org/examples/en/editor.html?c=pie-borderRadius (please do not use the same colors as for topics)
Indicators: i33AA, SV21
xAxisName:
yAxisName: average # trademarks per company
xColumnField: key
yColumnField: value
GroupingByField:
Filter: Non-expired (trademarks that haven’t expired)
Note:

Chart 3:
Title: Industry Trademarks by Company Size
Description: The graph displays the yearly average number of trademarks per company, in Agrifood in the EU, by number of employees. Data Sources: EUIPO, Orbis
Type: column
Indicators: i33AA SV15
xAxisName: number of employees
yAxisName: average # trademarks per company
xColumnField: key
yColumnField: value
GroupingByField:
Filter: Non-expired (trademarks that haven’t expired)
Note:

Chart 4:
Title: Industry Trademarks by Country
Description: The graph displays the yearly average number of trademarks per company, in Agrifood in the EU, by country. Data Sources: EUIPO, Orbis
Type: world map
Indicators: i32AA SV09
xAxisName: country
yAxisName: average # trademarks per company
xColumnField: key
yColumnField: value
GroupingByField:
Filter: Non-expired (trademarks that haven’t expired)
Note:

[dtziotzios]

First implementation deployed.

Issues:
Chart Group 1 - Chart 1 - Could not locate data. data. Please provide the file where the data exist.
Chart Group 1 - Chart 2 - Could not locate data. Please provide the file where the data exist.
Chart Group 1 - Chart 3 - Could not locate data. Please provide the file where the data exist.
Chart Group 2 - Chart 1 - We don't have Europe map for now. We 'll investigate how this can be implemented.
Chart Group 2 - Chart 3 - We don't support treemap with multiple levels. Further implementation is required.
Chart Group 3 - Not sure that we used the correct data. i31, i32, i33 for all charts. SV00 for the first. SV07 for the second. SV07b for the third. Please validate.
Chart Group 4 - Chart 2 - Data might be invalid. The i31AA SV05 has countries as the keys, not companies.
Chart Group 4 - Chart 3 - Data might be invalid. The i31AA SV15 has numbers as the keys, not companies.
Chart Group 6 - Chart 1 - Data might be invalid. The i33AA SV01 has decimals instead of text including the year.
Chart Group 6 - Note: How do we determine which trademarks are expired?

@gkountouris

[dtziotzios]

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

[dtziotzios]

@gkountouris The following issues exist:
Chart Group 2 - Chart 1 - We don't have Europe map for now. We 'll investigate how this can be implemented.
Chart Group 2 - Chart 3 - We don't support treemap with multiple levels. Further implementation is required.
Chart Group 4 - Chart 2 - Data might be invalid. The i31AA SV05 has countries as the keys, not companies.
Chart Group 4 - Chart 3 - Data might be invalid. The i31AA SV15 has numbers as the keys, not companies.
Chart Group 6 - Note: How do we determine which trademarks are expired?

[gkountouris]

@dtziotzios

Chart Group 2 - Chart 1 - We don't have Europe map for now. We 'll investigate how this can be implemented.
Chart Group 2 - Chart 3 - We don't support treemap with multiple levels. Further implementation is required.
Chart Group 6 - Note: How do we determine which trademarks are expired?

I cannot have an opinion about those issues @igrypari must answer.

Chart Group 4 - Chart 2 - Data might be invalid. The i31AA SV05 has countries as the keys, not companies.
For this chart I fixed the problem and now it has SDG not countries but also not companies. SDG is the right secondary view

Chart Group 4 - Chart 3 - Data might be invalid. The i31AA SV15 has numbers as the keys, not companies.
sv15 seems fine. It does not have numbers as keys but a string that indicates the range of the employees of the company.

[gkountouris]

@dtziotzios, @igrypari

Moreover

Chart Group 3

chart 1
You need to use i31_sv00, i32_sv00, i33_sv00
chart 2
You need to use i31_sv07, i32_sv07, i33_sv07
chart 3
You need to use i31_sv07b, i32_sv07b, i33_sv07b

What are you using now ? because the plots don't seem to be right.

[dtziotzios]

Requested changes are deployed.