Cheat Sheet: Data Wrangling

 


Package/MethodDescriptionCode Example
Replace missing data with frequencyReplace the missing values of the data set attribute with the mode common occurring entry in the column.
  1. 1
  2. 2
  1. MostFrequentEntry = df['attribute_name'].value_counts().idxmax() 
  2. df['attribute_name'].replace(np.nan,MostFrequentEntry,>df['attribute_name'].replace(np.nan,MostFrequentEntry, inplace=True)
Replace missing data with meanReplace the missing values of the data set attribute with the mean of all the entries in the column.
  1. 1
  2. 2
  1. AverageValue=df['attribute_name'].astype(<data_type>).mean(axis=0)
  2. df['attribute_name'].replace(np.nan, AverageValue, inplace=True)
Fix the data typesFix the data types of the columns in the dataframe.
  1. 1
  2. 2
  3. 3
  1. df[['attribute1_name', 'attribute2_name', ...]] = 
  2. df[['attribute1_name', 'attribute2_name', ...]].astype('data_type')
  3. #data_type is int, float, char, etc.
Data NormalizationNormalize the data in a column such that the values are restricted between 0 and 1.
  1. 1
  1. df['attribute_name'] = 
    df['attribute_name']/df['attribute_name'].max()
BinningCreate bins of data for better analysis and visualization.
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  1. bins = np.linspace(min(df['attribute_name']), 
  2. max(df['attribute_name'],n)
  3. # n is the number of bins needed 
  4. GroupNames = ['Group1','Group2','Group3,...]
  5. df['binned_attribute_name'] = 
  6. pd.cut(df['attribute_name'], bins, labels=GroupNames, include_lowest=True)
Change column nameChange the label name of a dataframe column.
  1. 1
  1. df.rename(columns={'old_name':\'new_name'}, inplace=True)
Indicator VariablesCreate indicator variables for categorical data.
  1. 1
  2. 2
  1. dummy_variable = pd.get_dummies(df['attribute_name'])
  2. df = pd.concat([df, dummy_variable],axis = 1)

Comments

Post a Comment

Popular posts from this blog

Common cybersecurity terminology

  As you’ve learned, cybersecurity (also known as security) is the practice of ensuring confidentiality, integrity, and availability of information by protecting networks, devices, people, and data from unauthorized access or criminal exploitation. In this reading, you’ll be introduced to some key terms used in the cybersecurity profession. Then, you’ll be provided with a resource that’s useful for staying informed about changes to cybersecurity terminology. Key cybersecurity terms and concepts There are many terms and concepts that are important for security professionals to know. Being familiar with them can help you better identify the threats that can harm organizations and people alike. A security analyst or cybersecurity analyst focuses on monitoring networks for breaches. They also help develop strategies to secure an organization and research information technology (IT) security trends to remain alert and informed about potential threats. Additionally, an analyst work...
Read more

Cheat Sheet: Plotting with Matplotlib using Pandas

Image
  Cheat Sheet : Plotting with Matplotlib using Pandas Plot Type Description Pandas Function Example Visual Line Plot Shows trends and changes over time DataFrame.plot.line() DataFrame.plot(kind = ‘line’) df.plot(x=’year’, y=’sales’, kind=’line’) Area Plot Displays data series as filled areas, showing the relationship between them DataFrame.plot.area() DataFrame.plot(kind = ‘area’) df.plot(kind='area') Histogram Displays bars representing the data count in each interval/bin Series.plot.hist() Series.plot(kind = ‘hist’, bins = n) s.plot(kind='hist', bins=10) df[‘age’].plot(kind='hist', bins=10) Bar Chart Displays data using rectangular bars DataFrame.plot.bar() DataFrame.plot(kind = ‘bar’) df.plot(kind='bar') Pie Chart Displays data as a circular plot divided into slices, representing proportions or percentages of a whole Series.plot.pie() Series.plot(kind = ‘pie’) DataFrame.plot.pie(y, labels) DataFrame.plot(kind = ‘pie’) s.plot(kind='pie’,autopct=...
Read more

Introduction to security frameworks and controls

  Imagine you're working as a security analyst and receive  multiple alerts about suspicious activity on the network.  You realize that you'll need to implement  additional security measures to keep  these alerts from becoming  serious incidents. But where do you start? Play video starting at ::17 and follow transcript 0:17 As an analyst, you'll start by identifying  your organization's critical assets and risks.  Then you'll implement  the necessary frameworks and controls. Play video starting at ::27 and follow transcript 0:27 In this video, we'll discuss how security professionals  use frameworks to continuously identify and manage risk.  We'll also cover how to use  security controls to manage or reduce specific risks. Play video starting at ::40 and follow transcript 0:40 Security frameworks are guidelines  used for building plans  to help mitigate risks and threats to data and privacy.  Security frameworks ...
Read more