notebook.community

Edit and run



In [1]:

    
import matplotlib.pyplot as plt
%matplotlib inline
import numpy as np
import pandas as pd
from mpl_toolkits.mplot3d.axes3d import Axes3D
%matplotlib notebook



In [2]:

    
dsname = './datasets/test.json'
mdsname = './datasets/mtest.json'
ort = 'split'
df = pd.read_json(dsname,typ='frame',orient=ort)
df.columns.name = 'file'
mdf= pd.read_json(mdsname,typ='frame',orient=ort)
mdf.columns.name = 'file'



In [3]:

    
mdf.head()









    Out[3]:







  
    
      file
      species
      humidity
      leg
      sex
      date
    
  
  
    
      l20170321_001.JDX
      albopictus
      39.3
      3
      m
      20170321
    
    
      l20170321_002.JDX
      albopictus
      39.3
      3
      m
      20170321
    
    
      l20170321_003.JDX
      albopictus
      39.3
      3
      m
      20170321
    
    
      l20170321_004.JDX
      albopictus
      39.3
      3
      m
      20170321
    
    
      l20170321_005.JDX
      albopictus
      39.3
      3
      m
      20170321



In [ ]:

file	species	humidity	leg	sex	date
l20170321_001.JDX	albopictus	39.3	3	m	20170321
l20170321_002.JDX	albopictus	39.3	3	m	20170321
l20170321_003.JDX	albopictus	39.3	3	m	20170321
l20170321_004.JDX	albopictus	39.3	3	m	20170321
l20170321_005.JDX	albopictus	39.3	3	m	20170321