title: json to pandas dataframe with first column value to be same across all rows
body: <p>I want to have two columns empname and empjosn, the empjson contains employee history in the json format. I want to convert this empjson column to normal data with all the details in a separate column along with empname column.</p>
  <p>When I try this code I getting output only for one row, I want this to be for all the values.</p>
  <pre><code>df[['alias','deptid','empid','mgnme','salary']] = pd.DataFrame.from_records(df['empjson'][0])
  </code></pre>
  <p>DataFrame:</p>
  <pre><code>| empname | empjson |
  | David   | [{'alias': 'xxxxx', 'deptid':   'P1021', 'empid': 10749, 'mgnme': 'hhhhh', 'salary': 20123}, {'alias':   'xxxxx', 'deptid': 'P1021', 'empid': 10749, 'mgnme': 'hhhhh', 'salary':   20123}, {'alias': 'xxxxx', 'deptid': 'P1021', 'empid': 10749, 'mgnme':   'hhhhh', 'salary': 20123}, {'alias': 'xxxxx', 'deptid': 'P1021', 'empid':   10749, 'mgnme': 'hhhhh', 'salary': 20123}, {'alias': 'xxxxx', 'deptid':   'P1021', 'empid': 10749, 'mgnme': 'hhhhh', 'salary': 20123}, {'alias':   'xxxxx', 'deptid': 'P1021', 'empid': 10749, 'mgnme': 'hhhhh', 'salary':   20123}, {'alias': 'xxxxx', 'deptid': 'P1021', 'empid': 10749, 'mgnme':   'hhhhh', 'salary': 20123}, {'alias': 'xxxxx', 'deptid': 'P1021', 'empid':   10749, 'mgnme': 'hhhhh', 'salary': 20123}, {'alias': 'xxxxx', 'deptid':   'P1021', 'empid': 10749, 'mgnme': 'hhhhh', 'salary': 20123}, {'alias':   'xxxxx', 'deptid': 'P1021', 'empid': 10749, 'mgnme': 'hhhhh', 'salary':   20123}, {'alias': 'xxxxx', 'deptid': 'P1021', 'empid': 10749, 'mgnme':   'hhhhh', 'salary': 20123}, {'alias': 'xxxxx', 'deptid': 'P1021', 'empid':   10749, 'mgnme': 'hhhhh', 'salary': 20123}, {'alias': 'xxxxx', 'deptid':   'P1021', 'empid': 10749, 'mgnme': 'hhhhh', 'salary': 20123}, {'alias':   'xxxxx', 'deptid': 'P1021', 'empid': 10749, 'mgnme': 'hhhhh', 'salary':   20123}, {'alias': 'xxxxx', 'deptid': 'P1021', 'empid': 10749, 'mgnme':   'hhhhh', 'salary': 20123}, {'alias': 'xxxxx', 'deptid': 'P1021', 'empid':   10749, 'mgnme': 'hhhhh', 'salary': 20123}, {'alias': 'xxxxx', 'deptid':   'P1021', 'empid': 1829, 'mgnme': 'hhhhh', 'salary': 1061}] |
  </code></pre>
  <p>Required Output:</p>
  <pre><code>| empname | alias | deptid | empid | mgnme | salary |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  | David   | xxxxx | P1021  | 10749 | yyyyy | 20123  |
  </code></pre>