Nested data is stored in .json files as shown in figure below

1.

• Nested data is stored in .json files as shown in figure below
Main data structure
Geotechnical data
Lab test children's
Field test children's
• Multiple locations are nested in
this format
• Each location has 4 children's as
• Dispersion data
• Velocity data
• Geotechnical data
• Spectral ratio
Geotechnical data has two
children's
• Lab tests
• Field tests

2.

Task 1
Python script to Read .json nested data, plot tabulated data
1. Script should be capable of plotting all the nested location data in json file
For example in current json there are two nested location, there may be 100 locations, so scripts should
be compatible of plotting all those locations.

3.

Plot 1
velocityProfile
Save as
locationame_velocityProfile .png
1.
Vs with depth
2.
Vp with depth

4.

Plot 2
dispersionData
Save as
locationame_dispersionData.png
Site dispersion &
theoretical dispersion
velocity with frequency on
same plot

5.

plot 3- labTest
nonlinearTest
grainSizeDistribution
Location_BRE
Location_GRE
100
1.0
0.9
0.8
80
Gs/Gmax
Portion Finer (%)
0.7
60
0.6
0.5
0.4
0.3
40
0.2
0.1
20
0.0
0.0001
0.001
0.01
0.1
1
10
100
10
100
Cyclic Shear Strain, gc (%)
0
0.01
0.1
1
10
Grain Size (mm)
Location_BRE
50
45
Save as locationame_labTest .png
Damping Ratio, l (%)
40
35
30
25
20
15
10
5
0
0.0001
0.001
0.01
0.1
1
Cyclic Shear Strain, gc (%)

6.

Plot 4-field test
conePenetrationTest
standardPenetrationTest
Tip resistance
(kPa)
SPT
0
10
20
30
40
50
60
0
5
Depth
BRE
15
20
25
Save as locationame_fieldTest .png
depth
10
slevee resistance
(kPa)
Pore pressure
(kPa)