Pandas in Python - Part 2

 There are several ways to filter records in Pandas.

  1. Boolean Indexing
  2. query() method
  3. loc attribute
  4. where() method


import pandas as pd
C_attack = pd.read_csv("C:\Cybersecurity\cybersecurity_attacks.csv")
C_attack
C_attack_New=C_attack[C_attack["Protocol"] =="UDP" ]
C_attack.size
C_attack_New.size
C_attack_New





Query_String = 'Protocol  !=  "UDP"'
C_attack.query(Query_String )



C_attack.where(C_attack["Packet Length"] > 1000)



C_attack.loc(C_attack["Packet Length"] > 1000)

Comments

Post a Comment

Popular posts from this blog

Pandas in Python .. Part 1

Image
Pandas in Python - Part 1 Pandas is a powerful Python library for data analysis and manipulation. It started in 2008 and provides data structures like DataFrames and Series, similar to spreadsheets and arrays mainly tabular data. Key features include: Data loading Data cleaning Data manipulation Data analysis Integration with other libraries Pandas has become an essential tool for data scientists, analysts, and researchers due to its efficiency, flexibility, and extensive capabilities. C_attack . columns C_attack . info () C_attack [ "Protocol" ] print ( C_attack . shape ) print ( C_attack .flags) print ( C_attack . size )
Read more

Python Decorators: Enhancing Your Data Functions with a Dash of Magic

  Python Decorators: Enhancing Your Data Functions with a Dash of Magic Hey there, code alchemists! We've journeyed through the essentials of Python for data science, from structuring our data to managing project environments. Now, let's explore a more advanced, yet incredibly powerful, Python feature that can elegantly enhance and extend the functionality of your functions without modifying their core code: Decorators . At first glance, decorators might seem a bit like wizardry. They use a special @ syntax, which looks a bit mysterious. But once you understand their underlying concept – that functions are first-class objects in Python (meaning they can be passed around, returned from other functions, and assigned to variables) – decorators become a surprisingly intuitive and incredibly useful tool, especially when building reusable components for your data science workflows. What's the Problem Decorators Solve? Imagine you have several data processing functions, and you ...
Read more