In [1]:
import requests
res = requests.get("https://api.airtable.com/v0/appNcYtL8fFZa1STA/iris?api_key=keyshdNC8CZdj1xgo")
print (res.text)
{"records":[{"id":"rec06Uv00gLHpXCsK","fields":{"花萼長度":"7","花萼寬度":"3.2","花瓣長度":"4.7","花瓣寬度":"1.4","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec0y2RIMZamslbup","fields":{"花萼長度":"6.4","花萼寬度":"3.2","花瓣長度":"5.3","花瓣寬度":"2.3","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec17ySNObqPFOjg4","fields":{"花萼長度":"7.7","花萼寬度":"2.6","花瓣長度":"6.9","花瓣寬度":"2.3","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec1J7cONXcIRFhVh","fields":{"花萼長度":"5.7","花萼寬度":"2.6","花瓣長度":"3.5","花瓣寬度":"1","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec1XA22s1BGzSKGk","fields":{"花萼長度":"5.5","花萼寬度":"2.4","花瓣長度":"3.8","花瓣寬度":"1.1","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec1urWZP4iLPq2Ss","fields":{"花萼長度":"6.3","花萼寬度":"2.5","花瓣長度":"4.9","花瓣寬度":"1.5","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec2aBWt0Z97RgJm1","fields":{"花萼長度":"5.8","花萼寬度":"2.7","花瓣長度":"4.1","花瓣寬度":"1","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec3XP3YhJFZFmZ1l","fields":{"花萼長度":"4.8","花萼寬度":"3.4","花瓣長度":"1.9","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec3mo6GI4DkmyIP2","fields":{"花萼長度":"4.8","花萼寬度":"3","花瓣長度":"1.4","花瓣寬度":"0.3","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec4V7rmCs2bmE38C","fields":{"花萼長度":"6.9","花萼寬度":"3.2","花瓣長度":"5.7","花瓣寬度":"2.3","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec4qy7HxlsnpKa3V","fields":{"花萼長度":"6.9","花萼寬度":"3.1","花瓣長度":"5.1","花瓣寬度":"2.3","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec4zDEzZplIWEQFW","fields":{"花萼長度":"4.7","花萼寬度":"3.2","花瓣長度":"1.3","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec64k6zyuTqedqVK","fields":{"花萼長度":"4.9","花萼寬度":"2.4","花瓣長度":"3.3","花瓣寬度":"1","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec6GoWmEduZN7sUH","fields":{"花萼長度":"6.2","花萼寬度":"2.8","花瓣長度":"4.8","花瓣寬度":"1.8","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec6H6IKCkAbKTAHP","fields":{"花萼長度":"6.1","花萼寬度":"2.8","花瓣長度":"4.7","花瓣寬度":"1.2","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec6Q7KRoDI9SGWbv","fields":{"花萼長度":"5.1","花萼寬度":"3.5","花瓣長度":"1.4","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec70sOWrnzt72YFm","fields":{"花萼長度":"5.5","花萼寬度":"3.5","花瓣長度":"1.3","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec7iAyzncq0bfu0J","fields":{"花萼長度":"5.8","花萼寬度":"2.7","花瓣長度":"3.9","花瓣寬度":"1.2","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec8AyatImPjsiCjC","fields":{"花萼長度":"7.1","花萼寬度":"3","花瓣長度":"5.9","花瓣寬度":"2.1","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"rec9NvprySYn0pcK1","fields":{"花萼長度":"5.8","花萼寬度":"2.6","花瓣長度":"4","花瓣寬度":"1.2","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recA9JO2ZkDX2dXAt","fields":{"花萼長度":"7.2","花萼寬度":"3","花瓣長度":"5.8","花瓣寬度":"1.6","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recACyvkw75AKJait","fields":{"花萼長度":"6","花萼寬度":"3","花瓣長度":"4.8","花瓣寬度":"1.8","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recB17Kiv9qeCdrHL","fields":{"花萼長度":"6.9","花萼寬度":"3.1","花瓣長度":"4.9","花瓣寬度":"1.5","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recB3UomHJPSGdODg","fields":{"花萼長度":"5","花萼寬度":"3.4","花瓣長度":"1.5","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recBBh5eprMXF8fPf","fields":{"花萼長度":"5.4","花萼寬度":"3.7","花瓣長度":"1.5","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recBrh5zYmPZQMqY0","fields":{"花萼長度":"4.7","花萼寬度":"3.2","花瓣長度":"1.6","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recC88DZdJ2XPaRSd","fields":{"花萼長度":"4.9","花萼寬度":"3.1","花瓣長度":"1.5","花瓣寬度":"0.1","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recCF4cEBHAbYDgUr","fields":{"花萼長度":"6.8","花萼寬度":"3","花瓣長度":"5.5","花瓣寬度":"2.1","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recCiSLXMzxKNGlGX","fields":{"花萼長度":"5.7","花萼寬度":"2.5","花瓣長度":"5","花瓣寬度":"2","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recCqNwQGDBHBLdHe","fields":{"花萼長度":"6.1","花萼寬度":"2.8","花瓣長度":"4","花瓣寬度":"1.3","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recD86JfmeLgqwEyt","fields":{"花萼長度":"5","花萼寬度":"3.5","花瓣長度":"1.6","花瓣寬度":"0.6","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recDMxz9hbHcQxzO7","fields":{"花萼長度":"5.3","花萼寬度":"3.7","花瓣長度":"1.5","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recDvVKrGg1hXF38Q","fields":{"花萼長度":"4.8","花萼寬度":"3","花瓣長度":"1.4","花瓣寬度":"0.1","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recDw8AxD6thpvct2","fields":{"花萼長度":"5.9","花萼寬度":"3","花瓣長度":"4.2","花瓣寬度":"1.5","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recF7v4FAeAengPIO","fields":{"花萼長度":"7.3","花萼寬度":"2.9","花瓣長度":"6.3","花瓣寬度":"1.8","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recFiHWxXfZe0Hn9q","fields":{"花萼長度":"5.6","花萼寬度":"2.8","花瓣長度":"4.9","花瓣寬度":"2","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recGQJPc44EFrTcqu","fields":{"花萼長度":"6.7","花萼寬度":"3.1","花瓣長度":"5.6","花瓣寬度":"2.4","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recGc7yneZ6ZDSKdY","fields":{"花萼長度":"4.4","花萼寬度":"2.9","花瓣長度":"1.4","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recGmBqbEALQjZ2Yv","fields":{"花萼長度":"5.6","花萼寬度":"3","花瓣長度":"4.5","花瓣寬度":"1.5","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recH4jgk937RBQUWm","fields":{"花萼長度":"6.3","花萼寬度":"3.3","花瓣長度":"4.7","花瓣寬度":"1.6","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recH5IyThN5qVSSD7","fields":{"花萼長度":"5.8","花萼寬度":"4","花瓣長度":"1.2","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recHMdmxYlvbdfEGt","fields":{"花萼長度":"5","花萼寬度":"2","花瓣長度":"3.5","花瓣寬度":"1","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recHNUzvVdsUYYvU2","fields":{"花萼長度":"5.5","花萼寬度":"2.3","花瓣長度":"4","花瓣寬度":"1.3","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recHg5jXfxT0pM2rR","fields":{"花萼長度":"5.1","花萼寬度":"2.5","花瓣長度":"3","花瓣寬度":"1.1","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recIP2gFyLSUxCgRx","fields":{"花萼長度":"5","花萼寬度":"3.3","花瓣長度":"1.4","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recIQ6dU5h3iGMdXX","fields":{"花萼長度":"6.7","花萼寬度":"3.3","花瓣長度":"5.7","花瓣寬度":"2.5","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recIpDKL638nZdQPv","fields":{"花萼長度":"5.4","花萼寬度":"3.9","花瓣長度":"1.7","花瓣寬度":"0.4","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recK87U0hMveMrkxN","fields":{"花萼長度":"5.7","花萼寬度":"3","花瓣長度":"4.2","花瓣寬度":"1.2","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recKMEPSWBdKCDWF8","fields":{"花萼長度":"4.6","花萼寬度":"3.6","花瓣長度":"1","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recKzvcmICCxPJZAW","fields":{"花萼長度":"6.3","花萼寬度":"2.9","花瓣長度":"5.6","花瓣寬度":"1.8","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recLLnQmIbm6trRQj","fields":{"花萼長度":"6.2","花萼寬度":"2.2","花瓣長度":"4.5","花瓣寬度":"1.5","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recLMstEI8eXv9fgP","fields":{"花萼長度":"6.4","花萼寬度":"3.1","花瓣長度":"5.5","花瓣寬度":"1.8","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recLnHMQxmFdGqQpg","fields":{"花萼長度":"5.8","花萼寬度":"2.7","花瓣長度":"5.1","花瓣寬度":"1.9","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recLpoWsZnqDAxeBW","fields":{"花萼長度":"6.5","花萼寬度":"2.8","花瓣長度":"4.6","花瓣寬度":"1.5","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recM39omdOgtCpiZj","fields":{"花萼長度":"6.7","花萼寬度":"3.3","花瓣長度":"5.7","花瓣寬度":"2.1","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recNAIgvmnBnvoU8e","fields":{"花萼長度":"5.7","花萼寬度":"2.8","花瓣長度":"4.1","花瓣寬度":"1.3","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recOfQpxFUeXAxFni","fields":{"花萼長度":"6.3","花萼寬度":"3.3","花瓣長度":"6","花瓣寬度":"2.5","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recP4pX7d2u0bUIgd","fields":{"花萼長度":"5.2","花萼寬度":"3.4","花瓣長度":"1.4","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recP9kqyFWKDiZuGn","fields":{"花萼長度":"6.5","花萼寬度":"3.2","花瓣長度":"5.1","花瓣寬度":"2","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recPbLTW9UIEXtyLm","fields":{"花萼長度":"5.6","花萼寬度":"3","花瓣長度":"4.1","花瓣寬度":"1.3","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recPgCqfuJdUrycHP","fields":{"花萼長度":"5","花萼寬度":"3.6","花瓣長度":"1.4","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recPyms21e2wGAmqc","fields":{"花萼長度":"6.7","花萼寬度":"3.1","花瓣長度":"4.4","花瓣寬度":"1.4","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recQ1aBG8Fqt3oGvv","fields":{"花萼長度":"6.9","花萼寬度":"3.1","花瓣長度":"5.4","花瓣寬度":"2.1","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recQ6OmhDomzLgUEA","fields":{"花萼長度":"7.7","花萼寬度":"3.8","花瓣長度":"6.7","花瓣寬度":"2.2","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recQ6a19USDh3EgqF","fields":{"花萼長度":"5.6","花萼寬度":"2.9","花瓣長度":"3.6","花瓣寬度":"1.3","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recQPtMFhyB1bLjs0","fields":{"花萼長度":"7.7","花萼寬度":"3","花瓣長度":"6.1","花瓣寬度":"2.3","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recQpMFyaGCEHcn3y","fields":{"花萼長度":"5.4","花萼寬度":"3.4","花瓣長度":"1.7","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recQqwVoEAGFNIftu","fields":{"花萼長度":"7.6","花萼寬度":"3","花瓣長度":"6.6","花瓣寬度":"2.1","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recS2MZXR8dTPthyZ","fields":{"花萼長度":"6.4","花萼寬度":"2.7","花瓣長度":"5.3","花瓣寬度":"1.9","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recSpU8zY9KjpueHD","fields":{"花萼長度":"6.4","花萼寬度":"2.8","花瓣長度":"5.6","花瓣寬度":"2.1","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recT1ewJ89R2szZTi","fields":{"花萼長度":"6.7","花萼寬度":"3.1","花瓣長度":"4.7","花瓣寬度":"1.5","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recT42GPbKNlg4bnz","fields":{"花萼長度":"5","花萼寬度":"3","花瓣長度":"1.6","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recTCwRVFG98PWfzJ","fields":{"花萼長度":"5.2","花萼寬度":"3.5","花瓣長度":"1.5","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recTX8dMb4UDxTKsS","fields":{"花萼長度":"4.8","花萼寬度":"3.4","花瓣長度":"1.6","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recToa44fDybGdX9H","fields":{"花萼長度":"6.4","花萼寬度":"2.8","花瓣長度":"5.6","花瓣寬度":"2.2","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recUBOyMnmDFxwZeV","fields":{"花萼長度":"6.1","花萼寬度":"3","花瓣長度":"4.6","花瓣寬度":"1.4","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recUbIeJjDMu0sfgu","fields":{"花萼長度":"5.6","花萼寬度":"2.5","花瓣長度":"3.9","花瓣寬度":"1.1","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recUl4D9kbIwbOJWE","fields":{"花萼長度":"6","花萼寬度":"2.2","花瓣長度":"5","花瓣寬度":"1.5","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recUnKce0Fj7gt07a","fields":{"花萼長度":"6.5","花萼寬度":"3","花瓣長度":"5.5","花瓣寬度":"1.8","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recVb8myOdgkCyw6h","fields":{"花萼長度":"6","花萼寬度":"2.2","花瓣長度":"4","花瓣寬度":"1","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recVxgyXlld8Ep3Sf","fields":{"花萼長度":"5.6","花萼寬度":"2.7","花瓣長度":"4.2","花瓣寬度":"1.3","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recXB4VklHRZOwagM","fields":{"花萼長度":"7.9","花萼寬度":"3.8","花瓣長度":"6.4","花瓣寬度":"2","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recXLkmm1o6q2MM2Z","fields":{"花萼長度":"4.4","花萼寬度":"3.2","花瓣長度":"1.3","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recY1T8WBChfdlWkQ","fields":{"花萼長度":"6.8","花萼寬度":"3.2","花瓣長度":"5.9","花瓣寬度":"2.3","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recYqxeUrpF5HRpWS","fields":{"花萼長度":"6.4","花萼寬度":"3.2","花瓣長度":"4.5","花瓣寬度":"1.5","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recZ4PEdhhlj5SkgY","fields":{"花萼長度":"4.5","花萼寬度":"2.3","花瓣長度":"1.3","花瓣寬度":"0.3","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recZQ6rE1eous7auT","fields":{"花萼長度":"4.9","花萼寬度":"2.5","花瓣長度":"4.5","花瓣寬度":"1.7","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recZSnXsloahGbYDY","fields":{"花萼長度":"6.5","花萼寬度":"3","花瓣長度":"5.8","花瓣寬度":"2.2","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recZZHAobc1TxGo12","fields":{"花萼長度":"5.1","花萼寬度":"3.7","花瓣長度":"1.5","花瓣寬度":"0.4","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recZgLzySNwrInV2J","fields":{"花萼長度":"6.3","花萼寬度":"2.7","花瓣長度":"4.9","花瓣寬度":"1.8","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recZlL0i0Mv32hhN1","fields":{"花萼長度":"4.8","花萼寬度":"3.1","花瓣長度":"1.6","花瓣寬度":"0.2","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recZwxNcgBFA6itXa","fields":{"花萼長度":"4.9","花萼寬度":"3.1","花瓣長度":"1.5","花瓣寬度":"0.1","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recaEvXLkLm6uvs8R","fields":{"花萼長度":"5.7","花萼寬度":"2.8","花瓣長度":"4.5","花瓣寬度":"1.3","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recatg4NXm96YyoR1","fields":{"花萼長度":"6.2","花萼寬度":"2.9","花瓣長度":"4.3","花瓣寬度":"1.3","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recb8CyCn9jPCRYVx","fields":{"花萼長度":"7.2","花萼寬度":"3.6","花瓣長度":"6.1","花瓣寬度":"2.5","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recbgEoAzAHUqZ8JX","fields":{"花萼長度":"6.1","花萼寬度":"2.6","花瓣長度":"5.6","花瓣寬度":"1.4","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recc6A3TIv23ugngM","fields":{"花萼長度":"6","花萼寬度":"2.7","花瓣長度":"5.1","花瓣寬度":"1.6","屬種":"Iris-versicolor"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"recd75vOOLlcCW6Or","fields":{"花萼長度":"5.7","花萼寬度":"3.8","花瓣長度":"1.7","花瓣寬度":"0.3","屬種":"Iris-setosa"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"receR5HUfuyleDQlV","fields":{"花萼長度":"6.7","花萼寬度":"2.5","花瓣長度":"5.8","花瓣寬度":"1.8","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"},{"id":"receSV9V4aHHQeFdK","fields":{"花萼長度":"6.2","花萼寬度":"3.4","花瓣長度":"5.4","花瓣寬度":"2.3","屬種":"Iris-virginica"},"createdTime":"2017-10-07T07:32:40.000Z"}],"offset":"itrQwErr7PUCSuqaJ/receSV9V4aHHQeFdK"}
In [2]:
import json
result = json.loads(res.text) #經過json.load後，從string轉為list type
result['records']
Out[2]:
[{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.4',
'花瓣長度': '4.7',
'花萼寬度': '3.2',
'花萼長度': '7'},
'id': 'rec06Uv00gLHpXCsK'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.3',
'花瓣長度': '5.3',
'花萼寬度': '3.2',
'花萼長度': '6.4'},
'id': 'rec0y2RIMZamslbup'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.3',
'花瓣長度': '6.9',
'花萼寬度': '2.6',
'花萼長度': '7.7'},
'id': 'rec17ySNObqPFOjg4'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1',
'花瓣長度': '3.5',
'花萼寬度': '2.6',
'花萼長度': '5.7'},
'id': 'rec1J7cONXcIRFhVh'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.1',
'花瓣長度': '3.8',
'花萼寬度': '2.4',
'花萼長度': '5.5'},
'id': 'rec1XA22s1BGzSKGk'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.5',
'花瓣長度': '4.9',
'花萼寬度': '2.5',
'花萼長度': '6.3'},
'id': 'rec1urWZP4iLPq2Ss'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1',
'花瓣長度': '4.1',
'花萼寬度': '2.7',
'花萼長度': '5.8'},
'id': 'rec2aBWt0Z97RgJm1'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.9',
'花萼寬度': '3.4',
'花萼長度': '4.8'},
'id': 'rec3XP3YhJFZFmZ1l'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.3',
'花瓣長度': '1.4',
'花萼寬度': '3',
'花萼長度': '4.8'},
'id': 'rec3mo6GI4DkmyIP2'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.3',
'花瓣長度': '5.7',
'花萼寬度': '3.2',
'花萼長度': '6.9'},
'id': 'rec4V7rmCs2bmE38C'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.3',
'花瓣長度': '5.1',
'花萼寬度': '3.1',
'花萼長度': '6.9'},
'id': 'rec4qy7HxlsnpKa3V'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.3',
'花萼寬度': '3.2',
'花萼長度': '4.7'},
'id': 'rec4zDEzZplIWEQFW'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1',
'花瓣長度': '3.3',
'花萼寬度': '2.4',
'花萼長度': '4.9'},
'id': 'rec64k6zyuTqedqVK'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '1.8',
'花瓣長度': '4.8',
'花萼寬度': '2.8',
'花萼長度': '6.2'},
'id': 'rec6GoWmEduZN7sUH'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.2',
'花瓣長度': '4.7',
'花萼寬度': '2.8',
'花萼長度': '6.1'},
'id': 'rec6H6IKCkAbKTAHP'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.4',
'花萼寬度': '3.5',
'花萼長度': '5.1'},
'id': 'rec6Q7KRoDI9SGWbv'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.3',
'花萼寬度': '3.5',
'花萼長度': '5.5'},
'id': 'rec70sOWrnzt72YFm'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.2',
'花瓣長度': '3.9',
'花萼寬度': '2.7',
'花萼長度': '5.8'},
'id': 'rec7iAyzncq0bfu0J'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.1',
'花瓣長度': '5.9',
'花萼寬度': '3',
'花萼長度': '7.1'},
'id': 'rec8AyatImPjsiCjC'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.2',
'花瓣長度': '4',
'花萼寬度': '2.6',
'花萼長度': '5.8'},
'id': 'rec9NvprySYn0pcK1'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '1.6',
'花瓣長度': '5.8',
'花萼寬度': '3',
'花萼長度': '7.2'},
'id': 'recA9JO2ZkDX2dXAt'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '1.8',
'花瓣長度': '4.8',
'花萼寬度': '3',
'花萼長度': '6'},
'id': 'recACyvkw75AKJait'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.5',
'花瓣長度': '4.9',
'花萼寬度': '3.1',
'花萼長度': '6.9'},
'id': 'recB17Kiv9qeCdrHL'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.5',
'花萼寬度': '3.4',
'花萼長度': '5'},
'id': 'recB3UomHJPSGdODg'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.5',
'花萼寬度': '3.7',
'花萼長度': '5.4'},
'id': 'recBBh5eprMXF8fPf'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.6',
'花萼寬度': '3.2',
'花萼長度': '4.7'},
'id': 'recBrh5zYmPZQMqY0'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.1',
'花瓣長度': '1.5',
'花萼寬度': '3.1',
'花萼長度': '4.9'},
'id': 'recC88DZdJ2XPaRSd'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.1',
'花瓣長度': '5.5',
'花萼寬度': '3',
'花萼長度': '6.8'},
'id': 'recCF4cEBHAbYDgUr'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2',
'花瓣長度': '5',
'花萼寬度': '2.5',
'花萼長度': '5.7'},
'id': 'recCiSLXMzxKNGlGX'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.3',
'花瓣長度': '4',
'花萼寬度': '2.8',
'花萼長度': '6.1'},
'id': 'recCqNwQGDBHBLdHe'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.6',
'花瓣長度': '1.6',
'花萼寬度': '3.5',
'花萼長度': '5'},
'id': 'recD86JfmeLgqwEyt'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.5',
'花萼寬度': '3.7',
'花萼長度': '5.3'},
'id': 'recDMxz9hbHcQxzO7'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.1',
'花瓣長度': '1.4',
'花萼寬度': '3',
'花萼長度': '4.8'},
'id': 'recDvVKrGg1hXF38Q'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.5',
'花瓣長度': '4.2',
'花萼寬度': '3',
'花萼長度': '5.9'},
'id': 'recDw8AxD6thpvct2'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '1.8',
'花瓣長度': '6.3',
'花萼寬度': '2.9',
'花萼長度': '7.3'},
'id': 'recF7v4FAeAengPIO'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2',
'花瓣長度': '4.9',
'花萼寬度': '2.8',
'花萼長度': '5.6'},
'id': 'recFiHWxXfZe0Hn9q'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.4',
'花瓣長度': '5.6',
'花萼寬度': '3.1',
'花萼長度': '6.7'},
'id': 'recGQJPc44EFrTcqu'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.4',
'花萼寬度': '2.9',
'花萼長度': '4.4'},
'id': 'recGc7yneZ6ZDSKdY'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.5',
'花瓣長度': '4.5',
'花萼寬度': '3',
'花萼長度': '5.6'},
'id': 'recGmBqbEALQjZ2Yv'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.6',
'花瓣長度': '4.7',
'花萼寬度': '3.3',
'花萼長度': '6.3'},
'id': 'recH4jgk937RBQUWm'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.2',
'花萼寬度': '4',
'花萼長度': '5.8'},
'id': 'recH5IyThN5qVSSD7'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1',
'花瓣長度': '3.5',
'花萼寬度': '2',
'花萼長度': '5'},
'id': 'recHMdmxYlvbdfEGt'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.3',
'花瓣長度': '4',
'花萼寬度': '2.3',
'花萼長度': '5.5'},
'id': 'recHNUzvVdsUYYvU2'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.1',
'花瓣長度': '3',
'花萼寬度': '2.5',
'花萼長度': '5.1'},
'id': 'recHg5jXfxT0pM2rR'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.4',
'花萼寬度': '3.3',
'花萼長度': '5'},
'id': 'recIP2gFyLSUxCgRx'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.5',
'花瓣長度': '5.7',
'花萼寬度': '3.3',
'花萼長度': '6.7'},
'id': 'recIQ6dU5h3iGMdXX'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.4',
'花瓣長度': '1.7',
'花萼寬度': '3.9',
'花萼長度': '5.4'},
'id': 'recIpDKL638nZdQPv'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.2',
'花瓣長度': '4.2',
'花萼寬度': '3',
'花萼長度': '5.7'},
'id': 'recK87U0hMveMrkxN'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1',
'花萼寬度': '3.6',
'花萼長度': '4.6'},
'id': 'recKMEPSWBdKCDWF8'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '1.8',
'花瓣長度': '5.6',
'花萼寬度': '2.9',
'花萼長度': '6.3'},
'id': 'recKzvcmICCxPJZAW'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.5',
'花瓣長度': '4.5',
'花萼寬度': '2.2',
'花萼長度': '6.2'},
'id': 'recLLnQmIbm6trRQj'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '1.8',
'花瓣長度': '5.5',
'花萼寬度': '3.1',
'花萼長度': '6.4'},
'id': 'recLMstEI8eXv9fgP'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '1.9',
'花瓣長度': '5.1',
'花萼寬度': '2.7',
'花萼長度': '5.8'},
'id': 'recLnHMQxmFdGqQpg'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.5',
'花瓣長度': '4.6',
'花萼寬度': '2.8',
'花萼長度': '6.5'},
'id': 'recLpoWsZnqDAxeBW'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.1',
'花瓣長度': '5.7',
'花萼寬度': '3.3',
'花萼長度': '6.7'},
'id': 'recM39omdOgtCpiZj'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.3',
'花瓣長度': '4.1',
'花萼寬度': '2.8',
'花萼長度': '5.7'},
'id': 'recNAIgvmnBnvoU8e'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.5',
'花瓣長度': '6',
'花萼寬度': '3.3',
'花萼長度': '6.3'},
'id': 'recOfQpxFUeXAxFni'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.4',
'花萼寬度': '3.4',
'花萼長度': '5.2'},
'id': 'recP4pX7d2u0bUIgd'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2',
'花瓣長度': '5.1',
'花萼寬度': '3.2',
'花萼長度': '6.5'},
'id': 'recP9kqyFWKDiZuGn'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.3',
'花瓣長度': '4.1',
'花萼寬度': '3',
'花萼長度': '5.6'},
'id': 'recPbLTW9UIEXtyLm'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.4',
'花萼寬度': '3.6',
'花萼長度': '5'},
'id': 'recPgCqfuJdUrycHP'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.4',
'花瓣長度': '4.4',
'花萼寬度': '3.1',
'花萼長度': '6.7'},
'id': 'recPyms21e2wGAmqc'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.1',
'花瓣長度': '5.4',
'花萼寬度': '3.1',
'花萼長度': '6.9'},
'id': 'recQ1aBG8Fqt3oGvv'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.2',
'花瓣長度': '6.7',
'花萼寬度': '3.8',
'花萼長度': '7.7'},
'id': 'recQ6OmhDomzLgUEA'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.3',
'花瓣長度': '3.6',
'花萼寬度': '2.9',
'花萼長度': '5.6'},
'id': 'recQ6a19USDh3EgqF'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.3',
'花瓣長度': '6.1',
'花萼寬度': '3',
'花萼長度': '7.7'},
'id': 'recQPtMFhyB1bLjs0'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.7',
'花萼寬度': '3.4',
'花萼長度': '5.4'},
'id': 'recQpMFyaGCEHcn3y'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.1',
'花瓣長度': '6.6',
'花萼寬度': '3',
'花萼長度': '7.6'},
'id': 'recQqwVoEAGFNIftu'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '1.9',
'花瓣長度': '5.3',
'花萼寬度': '2.7',
'花萼長度': '6.4'},
'id': 'recS2MZXR8dTPthyZ'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.1',
'花瓣長度': '5.6',
'花萼寬度': '2.8',
'花萼長度': '6.4'},
'id': 'recSpU8zY9KjpueHD'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.5',
'花瓣長度': '4.7',
'花萼寬度': '3.1',
'花萼長度': '6.7'},
'id': 'recT1ewJ89R2szZTi'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.6',
'花萼寬度': '3',
'花萼長度': '5'},
'id': 'recT42GPbKNlg4bnz'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.5',
'花萼寬度': '3.5',
'花萼長度': '5.2'},
'id': 'recTCwRVFG98PWfzJ'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.6',
'花萼寬度': '3.4',
'花萼長度': '4.8'},
'id': 'recTX8dMb4UDxTKsS'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.2',
'花瓣長度': '5.6',
'花萼寬度': '2.8',
'花萼長度': '6.4'},
'id': 'recToa44fDybGdX9H'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.4',
'花瓣長度': '4.6',
'花萼寬度': '3',
'花萼長度': '6.1'},
'id': 'recUBOyMnmDFxwZeV'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.1',
'花瓣長度': '3.9',
'花萼寬度': '2.5',
'花萼長度': '5.6'},
'id': 'recUbIeJjDMu0sfgu'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '1.5',
'花瓣長度': '5',
'花萼寬度': '2.2',
'花萼長度': '6'},
'id': 'recUl4D9kbIwbOJWE'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '1.8',
'花瓣長度': '5.5',
'花萼寬度': '3',
'花萼長度': '6.5'},
'id': 'recUnKce0Fj7gt07a'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1',
'花瓣長度': '4',
'花萼寬度': '2.2',
'花萼長度': '6'},
'id': 'recVb8myOdgkCyw6h'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.3',
'花瓣長度': '4.2',
'花萼寬度': '2.7',
'花萼長度': '5.6'},
'id': 'recVxgyXlld8Ep3Sf'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2',
'花瓣長度': '6.4',
'花萼寬度': '3.8',
'花萼長度': '7.9'},
'id': 'recXB4VklHRZOwagM'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.3',
'花萼寬度': '3.2',
'花萼長度': '4.4'},
'id': 'recXLkmm1o6q2MM2Z'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.3',
'花瓣長度': '5.9',
'花萼寬度': '3.2',
'花萼長度': '6.8'},
'id': 'recY1T8WBChfdlWkQ'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.5',
'花瓣長度': '4.5',
'花萼寬度': '3.2',
'花萼長度': '6.4'},
'id': 'recYqxeUrpF5HRpWS'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.3',
'花瓣長度': '1.3',
'花萼寬度': '2.3',
'花萼長度': '4.5'},
'id': 'recZ4PEdhhlj5SkgY'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '1.7',
'花瓣長度': '4.5',
'花萼寬度': '2.5',
'花萼長度': '4.9'},
'id': 'recZQ6rE1eous7auT'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.2',
'花瓣長度': '5.8',
'花萼寬度': '3',
'花萼長度': '6.5'},
'id': 'recZSnXsloahGbYDY'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.4',
'花瓣長度': '1.5',
'花萼寬度': '3.7',
'花萼長度': '5.1'},
'id': 'recZZHAobc1TxGo12'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '1.8',
'花瓣長度': '4.9',
'花萼寬度': '2.7',
'花萼長度': '6.3'},
'id': 'recZgLzySNwrInV2J'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.2',
'花瓣長度': '1.6',
'花萼寬度': '3.1',
'花萼長度': '4.8'},
'id': 'recZlL0i0Mv32hhN1'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.1',
'花瓣長度': '1.5',
'花萼寬度': '3.1',
'花萼長度': '4.9'},
'id': 'recZwxNcgBFA6itXa'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.3',
'花瓣長度': '4.5',
'花萼寬度': '2.8',
'花萼長度': '5.7'},
'id': 'recaEvXLkLm6uvs8R'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.3',
'花瓣長度': '4.3',
'花萼寬度': '2.9',
'花萼長度': '6.2'},
'id': 'recatg4NXm96YyoR1'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.5',
'花瓣長度': '6.1',
'花萼寬度': '3.6',
'花萼長度': '7.2'},
'id': 'recb8CyCn9jPCRYVx'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '1.4',
'花瓣長度': '5.6',
'花萼寬度': '2.6',
'花萼長度': '6.1'},
'id': 'recbgEoAzAHUqZ8JX'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-versicolor',
'花瓣寬度': '1.6',
'花瓣長度': '5.1',
'花萼寬度': '2.7',
'花萼長度': '6'},
'id': 'recc6A3TIv23ugngM'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-setosa',
'花瓣寬度': '0.3',
'花瓣長度': '1.7',
'花萼寬度': '3.8',
'花萼長度': '5.7'},
'id': 'recd75vOOLlcCW6Or'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '1.8',
'花瓣長度': '5.8',
'花萼寬度': '2.5',
'花萼長度': '6.7'},
'id': 'receR5HUfuyleDQlV'},
{'createdTime': '2017-10-07T07:32:40.000Z',
'fields': {'屬種': 'Iris-virginica',
'花瓣寬度': '2.3',
'花瓣長度': '5.4',
'花萼寬度': '3.4',
'花萼長度': '6.2'},
'id': 'receSV9V4aHHQeFdK'}]
In [3]:
import pandas as pd
df1 = pd.DataFrame(result['records'])
df1.head(3)
Out[3]:
createdTime
fields
id
0
2017-10-07T07:32:40.000Z
{'花萼長度': '7', '花萼寬度': '3.2', '花瓣長度': '4.7', '花...
rec06Uv00gLHpXCsK
1
2017-10-07T07:32:40.000Z
{'花萼長度': '6.4', '花萼寬度': '3.2', '花瓣長度': '5.3', ...
rec0y2RIMZamslbup
2
2017-10-07T07:32:40.000Z
{'花萼長度': '7.7', '花萼寬度': '2.6', '花瓣長度': '6.9', ...
rec17ySNObqPFOjg4
In [4]:
df_id = pd.DataFrame(df1['id'].tolist())
df_id.columns = ['id']
df_id.head(3)
Out[4]:
id
0
rec06Uv00gLHpXCsK
1
rec0y2RIMZamslbup
2
rec17ySNObqPFOjg4
In [5]:
df_ct = pd.DataFrame(df1['createdTime'].tolist())
df_ct.columns = ['createdTime']
df_ct.head(3)
Out[5]:
createdTime
0
2017-10-07T07:32:40.000Z
1
2017-10-07T07:32:40.000Z
2
2017-10-07T07:32:40.000Z
In [6]:
df_fields = pd.DataFrame(df1['fields'].tolist())
df_fields = df_fields[df_fields.columns[::-1]] #reverse columns order(option for view consistence)
df_fields.head(3)
Out[6]:
花萼長度
花萼寬度
花瓣長度
花瓣寬度
屬種
0
7
3.2
4.7
1.4
Iris-versicolor
1
6.4
3.2
5.3
2.3
Iris-virginica
2
7.7
2.6
6.9
2.3
Iris-virginica
In [7]:
#欄位合併
df_iris = pd.merge( df_id, df_fields, left_index=True, right_index=True)
df_iris = pd.merge( df_iris, df_ct, left_index=True, right_index=True)
df_iris.head(3)
Out[7]:
id
花萼長度
花萼寬度
花瓣長度
花瓣寬度
屬種
createdTime
0
rec06Uv00gLHpXCsK
7
3.2
4.7
1.4
Iris-versicolor
2017-10-07T07:32:40.000Z
1
rec0y2RIMZamslbup
6.4
3.2
5.3
2.3
Iris-virginica
2017-10-07T07:32:40.000Z
2
rec17ySNObqPFOjg4
7.7
2.6
6.9
2.3
Iris-virginica
2017-10-07T07:32:40.000Z
In [ ]:
Content source: OpenHCOS/HCOS
Similar notebooks: