title: Convert string from database to dataframe
body: <p>My database has a column where all the cells have a string of data. There are around 15-20 variables, where the information is assigned to the variables with an &quot;=&quot; and separated by a space. The number and names of the variables can differ in the individual cells... The issue I face is that the data is separated by spaces and so are some of the variables. The variable name is in every cell, so I can't just make the headers and add the values to the data frame like a csv. The solution also needs to be able to do this process automatically for all the new data in the database.</p>
  <p>Example:</p>
  <p>Cell 1: TITLE=&quot;Brothers Karamazov&quot; AUTHOR=&quot;Fyodor Dostoevsky&quot; PAGES=&quot;520&quot;... RELEASED=&quot;1880&quot;.</p>
  <p>Cell 2: TITLE=&quot;Moby Dick&quot; AUTHOR=&quot;Herman Melville&quot; PAGES=&quot;655&quot;... MAIN CHARACTER=&quot;Ishmael&quot;.</p>
  <p>I want to convert these strings of data into a structured dataframe like.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>TITLE</th>
  <th>AUTHOR</th>
  <th>PAGES</th>
  <th>RELEASED</th>
  <th>MAIN</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Brothers Karamazov</td>
  <td>Fyodor Dostoevsky</td>
  <td>520</td>
  <td>1880</td>
  <td>NaN</td>
  </tr>
  <tr>
  <td>Moby Dick</td>
  <td>Herman Meville</td>
  <td>655</td>
  <td>NaN</td>
  <td>Ishmael</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Any tips on how to move forwards? I have though about converting it into a JSON format by using the replace() function, before turning it into a dataframe, but have not yet succeeded. Any tips or ideas are much appreciated.</p>
  <p>Thanks,</p>