title: How do I clean this weird JSON data which I extracted from an excel file so that it becomes a proper dictionary?
body: <p>I have an excel file which has a JSON type of data. I extracted the data from the column of that Excel file and converted into dictionary using .to_dict() function. One cell of that column of the excel file looks like this, and there are more rows filled with same kind of data for that column:-</p>
  <blockquote>
  <p>{\currentPortfolioId&quot;:null/&quot;isNewRTQ&quot;:true/&quot;isNewInvestmentTenure&quot;:true/&quot;isNearTermVolatility&quot;:false/&quot;getPath&quot;:true/&quot;riskProfile&quot;:&quot;Moderate&quot;/&quot;initialInvestment&quot;:200000/&quot;cashflowDate&quot;:&quot;01-01-2021&quot;/&quot;currentWealth&quot;:200000/&quot;goalPriority&quot;:&quot;Wish&quot;/&quot;rebalancing&quot;:&quot;yearly&quot;/&quot;goalAmount&quot;:2000000/&quot;startDate&quot;:&quot;16-06-2021&quot;/&quot;endDate&quot;:&quot;01-01-2031&quot;/&quot;isNewGoalPriority&quot;:true/&quot;infusions&quot;:[0/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/10000/0]/&quot;scenario_type&quot;:&quot;regular&quot;/&quot;infusion_type&quot;:&quot;monthly&quot;/&quot;xforwardForValue&quot;:&quot;49.228.234.102:49907/ 13.86.190.104:3072/ 172.30.217.148:36243&quot;}&quot;</p>
  </blockquote>
  <p>As it is visible the data is not cleaned, with special characters like &quot;/&quot;, &quot;&quot;, &quot;&quot; etc.</p>
  <p>Can anyone help me in how to clean this data and convert it into a proper dictionary so that I can later do operations in it?</p>
  <p>I did try <code>ast.literal_eval()</code> but it doesn't seem to work.
  Please help!</p>