title: How to split and duplicate value in column pandas
body: <p>Hi I have a table where it's like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>date</th>
  <th>conversions</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>2022-05-01</td>
  <td>[{&quot;action_type&quot;:&quot;app_custom_event.LOGIN&quot;,&quot;value&quot;:&quot;25&quot;}]</td>
  </tr>
  <tr>
  <td>2022-05-02</td>
  <td>[{&quot;action_type&quot;:&quot;subscribe_mobile_app&quot;,&quot;value&quot;:&quot;1&quot;},{&quot;action_type&quot;:&quot;subscribe_total&quot;,&quot;value&quot;:&quot;1&quot;},{&quot;action_type&quot;:&quot;app_custom_event.LOGIN&quot;,&quot;value&quot;:&quot;237&quot;}]</td>
  </tr>
  <tr>
  <td>2022-05-03</td>
  <td>[{&quot;action_type&quot;:&quot;app_custom_event.LOGIN&quot;,&quot;value&quot;:&quot;21&quot;}]</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>What I want is to break the conversions event into columns.
  The end result is</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>date</th>
  <th>conversions type</th>
  <th>conversions value</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>2022-05-01</td>
  <td>app_custom_event.LOGIN</td>
  <td>25</td>
  </tr>
  <tr>
  <td>2022-05-02</td>
  <td>subscribe_mobile_app</td>
  <td>1</td>
  </tr>
  <tr>
  <td>2022-05-02</td>
  <td>subscribe_total</td>
  <td>1</td>
  </tr>
  <tr>
  <td>2022-05-02</td>
  <td>app_custom_event.LOGIN</td>
  <td>237</td>
  </tr>
  <tr>
  <td>2022-05-03</td>
  <td>app_custom_event.LOGIN</td>
  <td>21</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Right now I am stuck at</p>
  <pre><code>campaign_data_df[['conversions type','conversions value']]= campaign_data_df['conversions'].str.split(&quot;,&quot;, n = 2, expand = True)  
  campaign_data_df['conversions value']=campaign_data_df['conversions value'].str.extract('(\d+)')
  campaign_data_df['conversions type']=campaign_data_df['conversions type'].str.replace('[^a-zA-Z0-9]', ' ')
  campaign_data_df= campaign_data_df.drop(columns=['conversions'])
  campaign_data_df.to_csv('data/facebook/fb.csv', mode=&quot;w&quot;, header=True,index=False)
  </code></pre>
  <p>However this will work only with 2 types. What should I do?</p>