title: How to convert dictionary lists of different lengths into excel?
body: <p>When I write some crawler code, I save the final data in a dictionary list, but different dictionaries, their keys have some inconsistencies, but the total number of keys is certain, I am confused how to put them according to the dictionary keys , organize and generate an excel table, those properties that are not used can be replaced by NAN.</p>
  
  <p>I used pycharm to write this code and I thought it may use pandas to solve, but I still had no idea about how to do it.</p>
  
  <p>This is a simple pattern:</p>
  
  <pre><code>a = {'m': 1, 'n': 2}
  b = {'m': 3, 'n': 4, 'p': 5}
  c = {'m': 6, 'n': 7, 'o': 8, 'p': 9}
  d = [a, b, c]
  </code></pre>
  
  <p>The result I want to likes this:</p>
  
  <pre><code>        m   n   o   p
     0    1   2   NAN NAN
     1    3   4   NAN 5
     2    6   7   8   9
  </code></pre>