title: Copy and normalize medium pandas dataframe
body: <p>I have a medium sized sqllite database where a couple of the tables have 10's of millions of records. The data is not normalized. I want to copy the database, deleting tables, adding tables to normalize some of the columns, combining others, and splitting others. I do not control the original database.</p>
  <p>I've read <a href="https://stackoverflow.com/questions/16476924/how-to-iterate-over-rows-in-a-dataframe-in-pandas">How to iterate over rows in a DataFrame in Pandas</a> and the <a href="https://pandas.pydata.org/pandas-docs/stable/user_guide/basics.html#essential-basic-functionality" rel="nofollow noreferrer">https://pandas.pydata.org/pandas-docs/stable/user_guide/basics.html#essential-basic-functionality</a> but it still looks like I'm needing to iterate.</p>
  <p>This isn't a one time process, I will be getting updates from the original database on a regular basis. The update will occur on something like a monthly schedule so blazing speed isn't necessary but the update can't take forever.</p>
  <p>itertuples, pipe, or ...</p>