Data Science Explorer

I was working on data cleaning and faced a struggle today. I had to duplicate each row and put it together and did not know how to deal with this. It took me a few hours to think and look up the ways to figure it out. Luckily I found the way out so I am going to show you how I did it! Step #1: You have to import the data. import pandas as pd ss = pd.read_csv('/content/총물량데이터.csv') print (ss) Ste..

Today, after I finished data cleaning, I wanted to export the dataset into excel file. However, I did not know the way to export it. Luckily, I found the way out to export the file into excel file (.csv) on Google colab. from google.colab import files df.to_csv("filename.csv", index=False) files.download("filename.csv") I asked my coworkers and they kindly showed me how to export the file. I am ..

I was using the data that shows the amount of particulate matter in each region in Seoul and trying to draw a graph. Since we are conducting the project in Korean, we had to write the labels on graph in Korean. However, I encountered the trouble the error saying, WARNING:matplotlib.font_manager:findfont: Font family 'NanumBarunGothic' not found. Luckily, I solved the problem so I will show you h..

Yesterday, I made this fun project named Hangman and wanted to review the codes today. Let's dive in! Please refer to the following codes: import random import string from words import words def get_valid_word(words): word = random.choice(words) while '-' in word or ' ' in word: word = random.choice(words) return word.upper() def hangman(): word = get_valid_word(words) word_letters = set(word) a..