title: Create Pandas DataFrame from txt file with specific pattern
body: <p>I need to create a Pandas DataFrame based on a text file based on the following structure:                                        </p>
  
  <pre><code>Alabama[edit]
  Auburn (Auburn University)[1]
  Florence (University of North Alabama)
  Jacksonville (Jacksonville State University)[2]
  Livingston (University of West Alabama)[2]
  Montevallo (University of Montevallo)[2]
  Troy (Troy University)[2]
  Tuscaloosa (University of Alabama, Stillman College, Shelton State)[3][4]
  Tuskegee (Tuskegee University)[5]
  Alaska[edit]
  Fairbanks (University of Alaska Fairbanks)[2]
  Arizona[edit]
  Flagstaff (Northern Arizona University)[6]
  Tempe (Arizona State University)
  Tucson (University of Arizona)
  Arkansas[edit]
  </code></pre>
  
  <p>The rows with "[edit]" are States and the rows [number] are Regions. I need to split the following and repeat the State name for each Region Name thereafter.</p>
  
  <pre><code>Index          State          Region Name
  0              Alabama        Aurburn...
  1              Alabama        Florence...
  2              Alabama        Jacksonville...
  ...
  9              Alaska         Fairbanks...
  10             Alaska         Arizona...
  11             Alaska         Flagstaff...
  </code></pre>
  
  <p>Pandas DataFrame</p>
  
  <p>I not sure how to split the text file based on "[edit]" and "[number]" or "(characters)" into the respective columns and repeat the State Name for each Region Name. Please can anyone give me a starting point to begin with to accomplish the following.</p>