title: Python Data frame read json and filter data from dataframe
body: <p>I have json format like this</p>
  
  <pre><code>  {
    "2015": [
      {
        "DayofWeek": 4,
        "Date": "2015-02-06 00:00:00",
        "Year": 2015,
        "y": 43.2,
        "x": 10.397
      }
    ],
    "2016": [
      {
        "DayofWeek": 4,
        "Date": "2016-02-06 00:00:00",
        "Year": 2016,
        "y": 43.2,
        "x": 10.397,
        "Minute": 0
      }
    ],
    "2017": [
      {
        "DayofWeek": 4,
        "Date": "2017-02-06 00:00:00",
        "Year": 2017,
        "y": 43.2,
        "x": 10.397,
        "Minute": 0
      }
    ]
  }
  </code></pre>
  
  <p>I am reading JSON file like this, and after reading json file; converting it to data frame</p>
  
  <pre><code> with open('sample.json') as json_data:
      data = json.load(json_data)
  
  df=pd.DataFrame([data])
  </code></pre>
  
  <p>Now, I want filter data based on certain input key value like DayofWeek and Year etc.</p>
  
  <p><strong>Example:</strong> </p>
  
  <p><strong>Case1:</strong></p>
  
  <p>if input value is DayofWeek=4, then I want filter all objects having DayofWeek=4. </p>
  
  <p><strong>Case2:</strong></p>
  
  <p>if input value is both DayofWeek=4 and year=2017, then I want filter all the 2017 years data from json having DayofWeek=4. </p>
  
  <p>I have tried this code, but it is not working</p>
  
  <pre><code>filteredVal=df['2017']
  filter_v={'2015':{'DayofYear':4}}
  pd.Series(filter_v)
  </code></pre>