Month 3: Data Analysis and Visualization for Civil Engineers
Week 1: Data Handling with pandas
Day 1-2: Advanced pandas
Grouping, aggregating, and pivot tables.
Practice: Analyze project expenses by category and visualize them.
Day 3-4: Handling Missing Data
Fill, interpolate, or remove missing data.
Practice: Clean and prepare site survey data with missing values.
Day 5-6: Merging and Joining DataFrames
Combine multiple datasets for analysis.
Practice: Merge material costs and labor costs to generate a full project estimate.
Day 7: Review and Mini Project
Mini Project: Analyze a CSV file containing project costs and generate insights.
Week 2: Data Visualization
Day 8-9: Basic Plots (matplotlib and seaborn)
Line plots, bar plots, scatter plots.
Practice: Plot project timelines and resource usage.
Day 10-11: Advanced Visualization
Heatmaps, pair plots, and subplots.
Practice: Visualize soil test results or structural load distributions.
Day 12-13: Customizing Plots
Titles, labels, and legends.
Practice: Create a construction cost trend graph with all annotations.
Day 14: Review and Mini Project
Mini Project: Visualize project data, such as cost trends or material usage, with
annotated plots.
Week 3-4: Structural and Geospatial Applications
Day 15-16: Introduction to Structural Calculations
Perform beam or column load analysis using numpy and scipy.
Practice: Automate calculating bending moments for a beam under various loads.
Day 17-18: Geospatial Data Handling (geopandas)
Load and manipulate shapefiles or geospatial data.
Practice: Plot the project site and surrounding features on a map.
Day 19-20: Geospatial Visualization
Use geospatial libraries to create detailed maps.
Practice: Map soil types or utility lines for a site layout.
Day 21-22: Advanced Applications
Combine structural and geospatial data for decision-making.
Practice: Create a script to overlay terrain contours on a project layout.
Day 23-28: Final Month 3 Project
Project: Build a Python program to analyze structural loads and visualize site layout with
geospatial data.
Months 4-6: Advanced and Specialized Applications
1. Explore Computational Design: Learn parametric design workflows with
Rhino/Grasshopper and Python integrations like rhinoinside.
2. Dive into Machine Learning: Apply AI for predicting project delays or optimizing
schedules using scikit-learn.
3. Develop Professional Tools: Create standalone Python applications for project
management or cost estimation
