dtziotzios
commented
1 year ago 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
gkountouris
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: