πŸ“… 2023-07-30 β€” Session: Developed Python scripts for data visualization and processing

πŸ•’ 17:55–18:35
🏷️ Labels: Python, Pandas, Data Visualization, CSV, Seaborn, Data Processing
πŸ“‚ Project: Dev
⭐ Priority: MEDIUM

Session Goal

The session aimed to enhance data visualization and processing capabilities using Python libraries such as Seaborn and Pandas.

Key Activities

  • Color Palette Generation: Utilized Seaborn’s color_palette() function to create a color palette based on three colors, demonstrating how to interpolate colors effectively.
  • CSV to Dictionary Conversion: Demonstrated the use of Pandas to read a CSV file and convert a specific column from hexadecimal to RGB tuple format, and also mapping CSV contents into a dictionary.
  • Quantile Calculation: Provided code snippets for calculating 0.1 and 0.9 quantiles using Pandas’ quantile method and .agg() method for multiple quantiles.
  • Conditional Value Modification: Showcased a Python script to modify dictionary values conditionally based on CSV data.

Achievements

  • Successfully generated color palettes using Seaborn.
  • Converted CSV data into dictionary format with Pandas, including specific data transformations.
  • Calculated quantiles from a DataFrame using Pandas.
  • Implemented conditional logic to update dictionary values from CSV data.

Pending Tasks

  • Explore further data visualization techniques using Seaborn.
  • Optimize CSV data processing for larger datasets.