Collaborate with biomedical research team member in Shaanxi University of Chinese Medicine, skilled in SQL and Python for data extraction and analysis. Successfully filtered active molecules for colorectal cancer treatment, showcasing strong algorithm design and problem-solving abilities. Proficient in data visualization, able to create some basic machine learning model, driving results in academic projects.
I am responsible to filter the herb medicine's active molecule as well as their targets, and match those targets with the disease gene of colorectal cancer so that to interpret the potential therapeutic effect of the medicine.
In this course, I am asked to draw ER diagram to fulfill the business requirement, I got 87% for this assignment; The second assignment requires me to use SQL queries to extract the data from different relations that fulfill the requirements given.
I am asked to write an algorithm to find the paths in a maze, and should mark all the paths that I have tried but failed to go.
For the first project, I am finally asked to create paths for 4 people who maw the lawn simultaneously and stop at the same time as well, in the mean time, they should maw all the grass land when they stopped.
For the second project, I am asked to design a strategy/algorithm for a turn-based battle, and my strategy should read in the data of the player's defend/attack action, equipments, and help the player to win the game within the smallest number of turns. And also required to create visual image of energy bar and blood bar for player.