title: Python : Sum dictionary values in a dataframe
body: <p>I have a CSV file with the following layout /content<br />
  datetime,key_value_column<br />
  2022-02-02 00:00:01,&quot;{'key1':2,'key2':7,'key3':100}&quot;<br />
  2022-02-02 00:00:10,&quot;{'key5':2,'key2':3,'key3':1,'key4':5}&quot;</p>
  <p>The datetime column is unique</p>
  <p>I would like to have python script that sums the values in the dictionary for each row ie<br />
  2022-02-02 00:00:01,107<br />
  2022-02-02 00:00:10,11</p>
  <p>I can read the file</p>
  <pre><code>df = pd.read_csv('test.csv')
  print(df)```
  
  but no idea how to sum the dictionary values across the data frame  
  I worked out summing values for a dictionary example below but I am  
   hoping to get some hints on how to process the dataframe  
  
  ```adict = {'key1':2,'key2':7,'key3':100}
  sumvalues = adict.values()
  print(sum(sumvalues))```
  
  Thanks
  </code></pre>