回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我是python新手。我正在Azure数据块上运行python。我有一个.json文件。我把json文件的重要字段放在这里</p>
<pre><code>{
"school": [
{
"schoolid": "mr1",
"board": "cbse",
"principal": "akseal",
"schoolName": "dps",
"schoolCategory": "UNKNOWN",
"schoolType": "UNKNOWN",
"city": "mumbai",
"sixhour": true,
"weighting": 3,
"paymentMethods": [
"cash",
"cheque"
],
"contactDetails": [
{
"name": "picsa",
"type": "studentactivities",
"information": [
{
"type": "PHONE",
"detail": "+917597980"
}
]
}
],
"addressLocations": [
{
"locationType": "School",
"address": {
"countryCode": "IN",
"city": "Mumbai",
"zipCode": "400061",
"street": "Madh",
"buildingNumber": "80"
},
"Location": {
"latitude": 49.313885,
"longitude": 72.877426
},
</code></pre>
<p>我需要创建一个数据框,其中schoolName作为一列&;纬度及;经度是另外两列。你能告诉我怎么做吗</p>