How to use Streamlit to convert misidentified date terms from Excel to updated gene names

A web tool, Gene Updater, made by Streamlit to help preserve scientific data integrity and reproducibility

Kuan Rong Chan, Ph.D.
Omics Diary
Published in
2 min readJul 28, 2022

--

Gene Updater is a web tool made by Streamlit, which helps convert Excel auto-formatted terms back into updated gene names that are more resilient to autoconversion. For more details, users can read the publication in Scientific Reports

When gene expression data is opened in Excel, some of the gene symbols will be autoconverted into date terms. For instance, “SEPT1”…

--

--

Kuan Rong Chan, Ph.D.
Omics Diary

Kuan Rong Chan, PhD, Principal Research Scientist in Duke-NUS Medical School. Virologist | Data Scientist | Loves mahjong | Website: kuanrongchan.com