Jingwen Zhang

Data science practices

I have used Stata, Phthon, SQL and R for data collection, data cleaning, data analysis and data visulization.

The following C, Python and SQL codes I created are used to solve various problem sets that cover topics from basic to more advanced programming tasks, data architecture, artificial intelligence and machine learning algorithms.

One important lesson I learned is: Never lose patience and confidence because all the problems can be solved in the programming world.


CS50 Introduction to Computer Science

CS50 by Harvard University is a highly evaluated computer science course. I used several programming languages including C, python and SQL to deal with issues ranging from computational thinking, algorithms, data structures, data exploration, to computer science more generally.

Here I include my codes to solve the Problem sets of each topic. The original questions of each topic (week) can be found on CS50’s website. My codes to address the Practical problems and Labs of each topic can be found here.

Codes for Problem sets


CS50 Programming with Python

CS50 Programming with Python (CS50P) is another course offered by Harvard University. It disucsses various topics of Python programing more generally, such as functions, loops, test functions, exceptions, and object-oriented programming.

My codes for the Problem sets are linked below. The original questions of each topic/week can be found on CS50P’s website.

Codes for Problem sets


CS50 Artificial Intelligence with Python

This course from Harvard University explores the concepts and algorithms at the foundation of modern artificial intelligence, including topics like search design, optimization and neural networks, and textual analyses.

My codes for the weekly projects are shared here. The original questions of each project can be found on CS50AI’s website.

Codes for weekly projects


CS50 Databases with SQL

This course from Harvard University focuses on how to use SQL to create, update and design relational databases. It also discusses how to automate seraches with views and speed up searches with indexes.

My codes for the weekly projects are shared below. The original questions of each project can be found on CS50SQL’s website.

Codes for weekly projects


Machine learning Specialization

An excellent course for machine learning that covers various machine learning concepts, including supervised learning, unsupervised learning and reinforcement learning. I also applied different python libararies including Numpy, Tensorflow, Scikit-Learn to build machine learning models.

Due to copyrights, I do not share course materials and codes here. For more information, please check the course’s information on Coursera.