Evidence map›Paper›PMID 37733421›Full record

ArticleInteractive journal of medical research2023

Normal Workflow and Key Strategies for Data Cleaning Toward Real-World Data: Viewpoint.

Manping Guo, Yiming Wang, Qiaoning Yang, Rui Li, Yang Zhao, Chenfei Li, Mingbo Zhu, Yao Cui, Xin Jiang, Song Sheng and 2 more

Abstract read
In one paragraph

Article in Interactive journal of medical research, 2023. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 7 papers.

0numbers the graph read from it
0cells of the map it votes in
7citing papers in PubMed
–field-weighted citation impact
1 · What the graph read from it

What it found

Each row is one number read from the abstract, on the scale the paper reported it, with its interval. Left of the dashed line favours the treatment, right favours the comparator. Under each row is the sentence it came from. New to these charts? A ten-minute tutorial.

The abstract states no effect estimate the extractor could read, or names no intervention and outcome on the map, so this paper lights no cell and moves no belief. It is still indexed, cited and linked below.

2 · The registry

The trial behind it

Trials whose registry record cites this paper, or whose number appears in the abstract. A trial that started after this paper was published is citing it as background, not reporting it.

Neither the registry nor the abstract names a trial number. If this is a trial report, that itself is worth knowing.

3 · Its place in the literature

Who cites it

7 citing papers in PubMed.

  1. Article
  2. Article
  3. Article
  4. Article
  5. Article
  6. Article
  7. Article
4 · The record

Corrections and comments

PubMed lists nothing against this paper. Absence here is not a guarantee, only a check that was made.

5 · Who and what money

Authors and funding

12 authors.

Manping GuoPostdoctoral Research Station, China Academy of Chinese Medical Sciences, Beijing, China.ORCID https://orcid.org/0000-0001-9622-5383
Yiming WangXiyuan Hospital, China Academy of Chinese Medical Sciences, Beijing, China.ORCID https://orcid.org/0009-0002-2693-0348
Qiaoning YangXiyuan Hospital, China Academy of Chinese Medical Sciences, Beijing, China.ORCID https://orcid.org/0000-0001-5861-5778
Rui LiFirst Affiliated Hospital, Henan University of Traditional Chinese Medicine, Zhenzhou, China.ORCID https://orcid.org/0000-0002-4547-1637
Yang ZhaoXiyuan Hospital, China Academy of Chinese Medical Sciences, Beijing, China.ORCID https://orcid.org/0000-0002-1595-2368
Chenfei LiXiyuan Hospital, China Academy of Chinese Medical Sciences, Beijing, China.ORCID https://orcid.org/0009-0009-1330-754X
Mingbo ZhuBeijing Xinshi Yuanzhi Technology Consulting Co, Ltd, Beijing, China.ORCID https://orcid.org/0009-0000-9625-6948
Yao CuiBeijing Xinshi Yuanzhi Technology Consulting Co, Ltd, Beijing, China.ORCID https://orcid.org/0009-0009-8018-3823
Xin JiangBeijing Xinshi Yuanzhi Technology Consulting Co, Ltd, Beijing, China.ORCID https://orcid.org/0009-0008-9009-2645
Song ShengXiyuan Hospital, China Academy of Chinese Medical Sciences, Beijing, China.ORCID https://orcid.org/0000-0001-7827-1351
Qingna Li *Xiyuan Hospital, China Academy of Chinese Medical Sciences, Beijing, China.ORCID https://orcid.org/0000-0002-9604-4168
Rui Gao *Xiyuan Hospital, China Academy of Chinese Medical Sciences, Beijing, China.ORCID https://orcid.org/0000-0003-2455-7615

Funding

No grant is acknowledged in the PubMed record.

6 · The paper itself

Abstract

With the rapid development of science, technology, and engineering, large amounts of data have been generated in many fields in the past 20 years. In the process of medical research, data are constantly generated, and large amounts of real-world data form a "data disaster." Effective data analysis and mining are based on data availability and high data quality. The premise of high data quality is the need to clean the data. Data cleaning is the process of detecting and correcting "dirty data," which is the basis of data analysis and management. Moreover, data cleaning is a common technology for improving data quality. However, the current literature on real-world research provides little guidance on how to efficiently and ethically set up and perform data cleaning. To address this issue, we proposed a data cleaning framework for real-world research, focusing on the 3 most common types of dirty data (duplicate, missing, and outlier data), and a normal workflow for data cleaning to serve as a reference for the application of such technologies in future studies. We also provided relevant suggestions for common problems in data cleaning.

Indexed as

data cleaningdata qualitykey technologiesreal-world dataviewpoint

Identifiers

PMID37733421
PMCPMC10557005

What OpenQuestion holds

Textmetadata
LicenceCC BY
Read underepoch 390

Registered trials

None linked

Read under generation 80e0d062 · epoch 390. Bibliography from PubMed, PubMed Central and OpenAlex; grants from NIH RePORTER; trial links from ClinicalTrials.gov; estimates, votes and beliefs from the OpenQuestion graph.