FB Style Menu

Wednesday, February 9, 2022

How to play data in #Python


Excel မှာ လုပ်လေ့ရှိတဲ့ data cleaning, data manipulating တွေကို Python နဲ့ လုပ်ပြထားပါတယ်။
Excel မှာ ဒေတာတွေများလို့ processing time ကြာပြီး hang တာတွေ ကို Python နဲ့ဆို အရမ်းမြန်အောင် လုပ်နိုင်ပါတယ်။ Coding တစ်ခါ ရေးထားရင် ထပ်ခါ ထပ်ခါလုပ်ရတဲ့ manual work တွေကိုလဲ ရှောင်လို့ရတယ်။

Adventages of Python over Excel






Setting up Environment
Download
1. Python (free on Web)
2. Anaconda and Juptyer Notebook (free on Web)

# Importing pandas library
import pandas as pd

# To read excel or csv in python
Mydata = pd.read_csv ('D:\\Foldername1\\Foldername2\\filename.csv')
Mydata.head()

# Deleting column
Mydata.drop(['comumn-name'],axis=1,inplace=True)
Mydata

# Rename column
Mydata.rename({'Old name':'New name'},axis=1, inplace=True)
Mydata.head()

# Calculating in column
# In this example, I change Megabyte to Gigabyte the whole column. Data type need to be numeric !
GB = Mydata ['column name']/1024
GB.head(2)

# Adding new column in our dataframe
Mydata ['New column name']= GB
Mydata.head()

# Replace word in column name
Mydata.loc[:,'column name'] = Mydata.loc[:,'column name'].replace({'Old word':'New word'})
Mydata.head()

# Replacing word in the whole column string
Mydata['column name']= Mydata['column name'].str.replace('old word','new word') Mydata.head(2)

# Joining Table (or Vlookup)
# of course need two table to join together,which must have key column to index. In here let's consider as Mydata1 and Mydata2
Mergefile = Mydata1.merge(Mydata2,left_on='Mydata1 column name',right_on='Mydata2 column ame',how='left')
Mergefile.head()

# Export to excel
Mergefile.to_excel('D:\\Folder name\\Filename.xlsx')

By Nway

2 comments: