python - 从复杂字符串中提取信息

Question

嗨，我在 Panda Arrary 中有以下两列。如您所见，第二列中的信息有很多信息。据我了解，它是某种形式的“列表”，但使用双引号而不是单引号。

 Customer Name  Details
Jacob   "[{""Name"":""Phone"",""Value"":""03477444556""},{""Name"":""Type"",""Value"":""Apartment""},{""Name"":""No - Name"",""Value"":""1210""},{""Name"":""Apartment N    me"",""Value"":""Khudadaad Height  E-11\/1""},{""Name"":""Street"",""Value"":null},{""Name"":""Sector"",""Value"":null},{""Name"":""Landmark"",""Value"":null}]"
John    "[{""Name"":""Phone"",""Value"":""03477444550""},{""Name"":""Type"",""Value"":null},{""Name"":""No - Name"",""Value"":""10""},{""Name"":""Apartment Name"",""Val    e"":""Khudadaad Height  E-11\/1""},{""Name"":""Street"",""Value"":null},{""Name"":""Sector"",""Value"":null},{""Name"":""Landmark"",""Value"":null}]"
Smith   "[{""Name"":""Phone"",""Value"":""03475649292""},{""Name"":""Type"",""Value"":""House""},{""Name"":""No - Name"",""Value"":""1 a""},{""Name"":""Apartment Name""    ""Value"":null},{""Name"":""Street"",""Value"":null},{""Name"":""Sector"",""Value"":""f 7 3""},{""Name"":""Landmark"",""Value"":null}]"
Adam    "[{""Name"":""Phone"",""Value"":""03466700079""},{""Name"":""Type"",""Value"":""Office""},{""Name"":""No - Name"",""Value"":""ptcl head quarter""},{""Name"":""A    artment Name"",""Value"":null},{""Name"":""Street"",""Value"":null},{""Name"":""Sector"",""Value"":""g\/8\/4""},{""Name"":""Landmark"",""Value"":null}]"
Carlos  "[{""Name"":""Phone"",""Value"":""03466700079""},{""Name"":""Type"",""Value"":""Office""},{""Name"":""No - Name"",""Value"":""ptcl head quarter""},{""Name"":""A    artment Name"",""Value"":null},{""Name"":""Street"",""Value"":null},{""Name"":""Sector"",""Value"":""g\/8\/4""},{""Name"":""Landmark"",""Value"":null}]"
Ali     "[{""Name"":""Phone"",""Value"":""03465403134""},{""Name"":""Type"",""Value"":""House""},{""Name"":""No - Name"",""Value"":""55-B ""},{""Name"":""Apartment Name    ",""Value"":null},{""Name"":""Street"",""Value"":""21""},{""Name"":""Sector"",""Value"":""F 10\/2""},{""Name"":""Landmark"",""Value"":null}]"

无论如何，这就是我解释这些信息的方式。它包含针对每个客户的七个不同行，每行包含四个不同的值。因此，对于第一个客户 Jacob，第 1 行和第 4 列中的值是“03477444556”。每个客户的这一行包含他们的电话号码。同样，针对每个客户的第 3 行第 4 列包含他们的位置。

我有兴趣创建一个列，其中包含所有客户的电话号码。我该怎么做才能从上面得到这个：

Customer Name | Phone Number 
  Jacob         |  03477444556 
  John          | 034777444550 
  Smith         |  03475649292 
  Adam          |  03466700079 
  Carlos        |  03466700079 
  Ali           |  03465403132 

并且能够对主列中包含的任何信息执行上述操作。

标签： pythonstring