title: From a bunch of csv to json
body: <p>(I can't edit the title of this question: <a href="https://stackoverflow.com/questions/44326723/add-an-array-to-a-dataframe">https://stackoverflow.com/questions/44326723/add-an-array-to-a-dataframe</a> and I think I don't have answers by the title.... I hope this can help)</p>
  <p>I'm reading information from different .csv and I need to convert it to a .json</p>
  <p>1.csv is:</p>
  <pre><code>field1: 1value1, field2: 1value2, field3: 1value3
  </code></pre>
  <p>The 2.csv have a lot of rows and I have to filter by 1value3</p>
  <pre><code>row1field1: 2value1, row1field2: 2value2, row1field3: 1value3, row1field4: 3.csv, 
  row2field1: 2value4, row2field2: 2value5, row2field3: 1value3, row2field4: 4.csv,
  </code></pre>
  <p>3.csv is:</p>
  <pre><code>field1: 3value1, field2: 3value2
  </code></pre>
  <p>4.csv is:</p>
  <pre><code>field1: 4value1, field2: 4value2
  </code></pre>
  <p>I need my final json looks like:</p>
  <pre><code>{
      &quot;field1&quot;: &quot;1value1&quot;,
      &quot;field2&quot;: &quot;1value2&quot;,
      &quot;field3&quot;: &quot;1value3&quot;,
      &quot;talbes&quot;: [
          {
              &quot;row1field1&quot;: &quot;2value1&quot;,
              &quot;row1field2&quot;: &quot;2value2&quot;,
              &quot;row1field3&quot;: &quot;1value3&quot;,
              &quot;fieldsFromTable&quot;: [
                  {
                      &quot;field1&quot;: &quot;3value1&quot;,
                      &quot;field2&quot;: &quot;3value2&quot;
                  }
              ]
          },
          {
              &quot;row2field1&quot;: &quot;2value4&quot;,
              &quot;row1field2&quot;: &quot;2value5&quot;,
              &quot;row1field3&quot;: &quot;1value3&quot;,
              &quot;fieldsFromTable&quot;: [
                  {
                      &quot;field1&quot;: &quot;4value1&quot;,
                      &quot;field2&quot;: &quot;4value2&quot;
                  }
              ]
          }
      ]
  }
  </code></pre>
  <p>I'm trying to works with dataFrame to convert after with dataFrame.to_json(), but I can't achieve to store an array of dataFrame into other dataframe... and really I don't know which is the better aprox to it.</p>
  <p>Thanks</p>
  <p>(I know it's a little messy this explanation... sorry)</p>