Research Article

Bidders Recommender for Public Procurement Auctions Using Machine Learning: Data Analysis, Algorithm, and Case Study with Tenders from Spain

Table 4

Quantitative description of the company dataset.

TopicDescriptionValue

General valuesTotal number of companies in the dataset1,353,213
Total number of opened companies (actives)831,356 (61.44%)
Total number of closed companies (inactives)521,857 (38.56%)
Temporal range of the opened companies’ establishment date1842/03/17–2019/03/25
Mean of the opened companies’ establishment date (seniority date)2002/12/18
Mean employees of opened companies (actives)11.51
Total number of the opened companies of legal entity type: private company limited by shares (Ltd.) (SL in Spanish)761,358 (91.58%)

Total number of the opened companies of legal entity type: public limited company (PLC) (SA in Spanish)60,633 (7.29%)
Dataset’s variablesCIF, Establishment_Date, Legal_Form, Last_Available_Year_Info, Status_Company, City_Company, Province_Company, Latitude_Company, Longitude_Company, Employees, Operating_Income, EBIT, EBITDA, CNAE_Primary, CNAE_Secondary, NACE2_Primary, NACE2_Secondary, IAE_Primary, IAE_Secondary, SIC_Primary, SIC_Secondary, NAICS_Primary, and NAICS_Secondary23 variables (description in Table 2)

Operating income, EBIT, and EBITDATotal number of opened companies with annual operating income available information (data from 2006 to 2018)14,695 (2006); 22,080 (2007); 31,067; 38,120; 46,762; 85,210; 460,751; 589,239; 621,926; 659,266; 694,059; 648,598; 124,514 (2018)
Total number of opened companies with annual EBIT available information (data from 2006 to 2018)16,642 (2006); 24,618 (2007); 35,441; 41,558; 50,253; 89,890; 476,655; 608,397; 640,520; 677,366; 711,972; 663,761; 127,267 (2018);
Total number of opened companies with annual EBITDA available information (data from 2006 to 2018)16,654 (2006); 24,637 (2007); 35,452; 41,571; 50,266; 89,917; 476,719; 608,482; 640,623; 677,468; 712,085; 663,880; 127,295 (2018)
Mean operating income of the year 2018€4,122,727.11
Median operating income of the year 2018€299,130.00
Mean EBIT of the year 2018€397,964.64
Median EBIT of the year 2018€10,472.40
Mean EBITDA of the year 2018€542,772.79
Median EBITDA of the year 2018€18,733.35

Number of opened companies by location (province)Top 1: number of opened companies from Madrid157,705 (18.97%)
Top 2: number of opened companies from Barcelona114,207 (13.74%)
Top 3: number of opened companies from Valencia45,590 (5.48%)
Top 4: number of opened companies from Alicante33,386 (4.02%)
Top 5: number of opened companies from Sevilla26,368 (3.17%)