Day-5

Day 5 of #100DaysOfCode

Task

1. Learn Pandas

• Reading/Writing with different formats like json, excel, csv, sql etc...
• Data Analysis Project (EDA) (70%)

Resources

• Python Pandas Tutorial Playlist by Corey Schafer YT channel: (Playlist link)
• Stack Overflow Developer Survey 2021 (link)
• FreeCodeCamp Demographic Data Analyzer

Topics I have learnt

1. Reading/Writing data in
   • CSV/TSV
   • JSON
   • EXCEL
   • SQL
2. FreeCodeCamp Demographic Data Analyzer project (70% done)

Software used

• Jupyter Notebook
• Python 3.10.2
• Numpy 1.22.4
• pandas 1.4.2
• SQLAlchemy 1.4.37
• PyMySQL 1.0.2

My Notebooks

• Pandas_tutorial_part_11.ipynb
• Data_analysis_project_2.ipynb

Conclusion:

Today I learnt how to read and write data in different formats like csv, json, excel & sql. Also did EDA on FreeCodeCamp's Demographic Data Analyzer (70% done). Both things are so interesting.