Bridge in Pittsburg
ID Purpose Length Lanes Clear TorD Material Span Rel-L
E2 Highway 1037 2 N Through Wood Short S
E3 Aqueduct ? 1 N Through Wood ? S
E5 Highway 1000 2 N Through Wood Short S
E6 Highway ? 2 N Through Wood ? S
E7 Highway 990 2 N Through Wood Medium S
E8 Aqueduct 1000 1 N Through Iron Short S
E9 Highway 1500 2 N Through Iron Short S
E10 Aqueduct ? 1 N Deck Wood ? S
E11 Highway 1000 2 N Through Wood Medium S
E12 RR ? 2 N Deck Wood ? S
E14 Highway 1200 2 N Through Wood Medium S
E13 Highway ? 2 N Through Wood ? S
E15 RR ? 2 N Through Wood ? S
E16 Highway 1030 2 N Through Iron Medium S-F
E17 RR 1000 2 N Through Iron Medium ?
E18 RR 1200 2 N Through Iron Short S
E19 Highway 1000 2 N Through Wood Medium S
E20 Highway 1000 2 N Through Wood Medium S
E21 RR ? 2 ? Through Iron ? ?
E23 Highway 1245 ? ? Through Steel Long F
E22 Highway 1200 4 G Through Wood Short S
E24 RR ? 2 G ? Steel ? ?
E25 RR ? 2 G ? Steel ? ?
E27 RR ? 2 G Through Steel ? F
E26 RR 1150 2 G Through Steel Medium S
E30 RR ? 2 G Through Steel Medium F
E29 Highway 1080 2 G Through Steel Medium ?
E28 Highway 1000 2 G Through Steel Medium S
E32 Highway ? 2 G Through Iron Medium F
E31 RR 1161 2 G Through Steel Medium S
Bridge in Pittsburg
E34 RR 4558 2 G Through Steel Long F
In the data set of bridges in Pittsburgh, several instances have missing values.
Complete the following tasks to ensure accurate analysis:
a. Data Cleaning:
• Address Missing Values:
sing appropriate data imputation techniques (e.g., mean substitution,
interpolation, etc.). Ensure that the data is clean and ready for analysis.
Are there any potential biases introduced by the missing data, and how
might you mitigate them?
b. Establish Relationships:
i. Length of the Bridge and Purpose:
• Analyze the relationship between the length of the bridge and its purpose. How
does the purpose of the bridge affect its length?
ii. Number of Lanes and Materials:
• Investigate the relationship between the number of lanes and the material of the
bridge. Are certain materials more commonly used for bridges with a specific
number of lanes?
iii. Span of the Bridge and Number of Lanes:
• Examine the relationship between the span of the bridge and the number of
lanes. How do these two attributes influence each other, and are there any
observable patterns based on span length?