OCDS References

Home › OCDS References

OCDS references

How to filter PhilGEPS data with R and R Studio

PRE-REQUISITE: You must have R and R Studio BOTH installed in your computer. If you don’t, download the installers on the following links and install them to your computer!

R - https://cran.stat.upd.edu.ph
R Studio - https://www.rstudio.com/

Once your have R and R Studio both up and running, we can now proceed to the filtering!

STEP 1 – Go to www.PHILGEPS.GOV.PH and go to the “Open Data” Section. Try downloading the excel files they have over there. We often use the datasets of the Invitations to Bid and Notices of Award.

STEP 2 – The files are in XLSX format. We prefer to export them to CSV because its easier to ingest and because csv is #OPENData format. So yeah. ALSO! Make sure that the rows do not have blanks on the top. The top row will automatically become the ‘header’ once it is ingested in R Studio so make sure the top row is the row that contains the column labels (except if you you key in more lines of course, so let’s keep it simple).

STEP 3 – Ingest the CSV file in RStudio as a dataframe. Normally, we do the following:

DATA_FRAME_NAME = read.csv("PATH/TO/FILE.csv")

STEP 4 – Now that you have a dataframe in R, you can now perform basic operations on it. For example, we normally filter the name of the agency that we are interested in. For example we do something like:

DATA_FRAME_NAME_NEW <- subset(DATA_FRAME_NAME, ColumnName==”ParameterHere”)
example:

JUL_SEP_2018_sub <- subset(JUL_SEP_2018, Organization.Name=="DEPARTMENT OF HEALTH - REGIONAL OFFICE V")

We now have a NEW Dataframe, with only the data from Department of Health Regional Office 5. 🙂 But remember! The stings are case sensitive so you have to make sure that you are inputting the correct name. You can do a quick search in the raw table and copy-paste the parameter just to be sure 🙂

You can perform several other operations on the dataframe! You can remove columns, count occurrences, join two or more dataframes, and more. To find out more operations, you can google for “R Cheatsheets” for commands and examples.

STEP 5 – If you are satisfied with your final dataframe, we request that you save it as a CSV file through the following commands: 

write.csv(DATA_FRAME_NAME, file=”PREFERRED_FILE_NAME.csv”

This is because, chances are, some other researcher, or concerned citizen (who isn’t familiar with R) would need the dataset you just made. Sharing is Caring! 🙂

STEP 6 – Finally, you can share your cleaned datasets in our repository! We will make sure to credit you with your preferred name/nickname. Send us your dataset and we will upload it for you (for now. We are working on a way so that you can upload by yourself :) )

All data uploaded will be available as open datasets. They are free for all, so that we can encourage more and more researchers, advocates, to use data and be data-driven in their decision making.

Thank you very much! For more information, kindly email support@layertechlab.com. From time to time, we conduct hands-on trainings! Please let us know if you are interested!

First Stakeholder Meeting – Open Contracting Data Standards Stakeholder Meeting 2018

Held at The Oriental Hotel on May 22, 2018, Layertech Software Labs and Hivos conducted the first stakeholder meeting to officially kickstart the Open Contracting and OCDex project in Legazpi city, Albay.

The objective of the meeting is to present the Open Contracting project objectives, proposed activities, and solicit stakeholder feedback and support in order to understand the current issues and difficulties they encounter in public procurement.

Furthermore, in order to create a user-friendly, functional, and relevant procurement portal, stakeholders need to be a constant part of the development process, making them co-creators of the OCDex portal.

Meeting attendees include civil society organizations, local businessmen, members of the academe, and representatives of the Local Government Unit (LGU) of Legazpi.

OCDex team presenting OCDS and potential benefits to stakeholders

The meeting aims to ensure that the OCDex portal, its features, and contents will benefit target stakeholders and assist them in their future procurement planning and decision making activities.

SeeLog: Open Contracting Data Standard-Based Procurement Portal

By: Alan John Maristela Alilano

The IT industry has come a long way to its existing shape where it is playing a very dominant role in our sphere of life. It has made revolutionary changes in information gathering and dissemination as well as in global communication. The advancement in the field of information technology helped many people in terms of storing, retrieving, transmitting information, and in communicating. Today, people are still looking for ways and inventing things that will benefit those in the future generation.

At present, the figures being presented at Philippine Government Electronic Procurement System (PhilGEPS) is too technical that the public is having difficulties in understanding its contents.

With such findings, the researchers believed that a well-managed, web-based, Open Contracting Data Standard(OCDS)-based, Monitoring System that uses data visualization can improve the current state on how the taxpaying public understand the procurement process of the Philippines.


Sample Screenshot of SeeLog POC Version

The proposed SeeLog: OCDS Based Procurement Portal will provide the compliance checking of the documents of the tendered items/services. A module will also be provided by the researchers that will mark low-rated procurement transactions for future investigation. The public, on the other hand, will be provided by a Freedom wall where they can show their thoughts and comments. The module will also track the complaints sent by the general public and send it to the concerned parties as feedback mechanisms.

Sample Screenshot of SeeLog POC Version

Sample Screenshot of SeeLog POC Version

Note: SeeLog is developed by graduating Bicol University IT Students, as interns, under Layertech Software Labs and Bicol University partnership for the OCDEx Project.

 The next step would be a pilot phase, integration to live OCDEx portal.