The Rancho Data Crawler
The Rancho Data Crawler is a web-application that given a complex search string, crawls study-level metadata in PubMed, ClinicalTrials.gov, GEO, SRA, EGA, and ArrayExpress and outputs results to an XLSX (Excel) file within minutes. This application is meant to accelerate the data crawling process by putting our proprietary Rancho data crawler scripts at the fingertips of any project team that needs them, no scripting needed.


The Fuzzy Logic Tool
Supports rapid, practical data harmonization based on phonetic alignment. When building this term-mapping solution, we found that existing methods are either too restrictive (statistical methods) or too permissive (Soundex method).
Our Fuzzy Tool algorithm has been implemented as an API in addition to an Excel plugin. The implementation provides a two-pronged approach to accelerate the mapping process: first, identifying the best ontologies to map the data and subsequently leveraging an indexed ontology.

The Rancho QC Tool
Automatic Quality Control (QC) Tool:
To enhance QC efficiency and ensure consistent QC output standards, Rancho has developed a tool to support and facilitate tabular data QC and streamline quality control measures for data model alignment. This QC tool will enable users to perform data transformations, generate table summaries, and build logical tests using an RShiny interface. Further details on the tool's functions and features, as well as instructions for use, are documented in Rancho KB.
Benefits of Rancho’s QC Tool:
-
Clear and user-friendly interface (without coding requirements)
-
Faster quality assurance and issue resolution
-
Less effort to achieve compliance
-
Consistent standards for quality control documentation
-
High-quality data model and tabular deliverables
-
Streamlined and repeatable
Rancho Accelerators
Rancho BioSciences’ Accelerators are powerful tools designed to significantly reduce the amount of time and resources spent on a project. These automated tools can be used to replace and/or improve existing protocols, and are also customizable to meet your project’s specific needs. Our Accelerators include:
TMS:
Rancho BioSciences’ Terminology-Mapping Solution takes a two-pronged approach to ontologies: select the best ontologies to map to, then pre-index standard ontology terms for efficient mapping. TMS’s capabilities include:

CAT:
Our Categorization Tool is a QC Accelerator that enables data scientists to complete projects with a higher degree of efficiency and accuracy. CAT can drastically reduce time spent on QC, and virtually eliminates human error. CAT’s capabilities include:
Data Crawler:
Rancho’s Data Crawler lets users crawl, manage and enrich data and metadata from PubMed, ClinicalTrials.gov, and other commonly used public resources. “Light Crawler” and “Deep Crawler” modes are customizable to your project’s needs to provide an efficient yet comprehensive search experience. Data Crawler’s capabilities include:

Light Crawler lets users extract valuable information from their target publications. The Light Crawler can be used for:
Deep Crawler is designed to gather sample-level metadata from publications. The Deep Crawler can be used for:
Our Data Technology and Tool Kits
The Rancho Tool Kit is a collection of processing and analysis code that accelerates analysis, streamlines the QC process, and encourages the development of professional, consistent, and accessible scientific products.
Rancho has been developing content and tools since 2012. Over the years, we generated a lot of in-house technology that we bring to projects and produce high-quality, efficient results for our clients.
SMART Converter
Is a platform to collect data from clinical data sites—simultaneously checks for updates, downloads, and converts data to a format that is FAIR. Minimizes human time spent on data updates and facilitates rapid data ingestion into a platform of choice.
