title: Read text file data to pandas DataFrame
body: <p>I have specific file format from CNC (<em>work center</em>) data. saved like .txt . 
  I want read this table to pandas dataframe but i never seen this format before.</p>
  
  <pre><code>_MASCHINENNUMMER    : &gt;0-251-11-0950/51&lt;     SACHBEARB.: &gt;BSTWIN32&lt;
  _PRODUKTSCHLUESSEL  : &gt;BST 500&lt;           DATUM     : &gt;05-20-2016&lt;
  ---------------------------------------------------------------------------
  *BOHRKOPF !SPINDEL!WK!DELTA-X   !DELTA-Y   !DURCHMESSER! KOMMENTAR
  ----------+----------+----------+----------+-----------+-------------------
  [NoValidForUse]
  A21       !      1!62!     0.000!     0.000!      0.000!
  [V11]
  A12       !     -1!62!     0.000!  -160.000!      0.000!
  A12       !      2!62!     0.000!  -128.000!      3.000!  70.0
  A12       !     -3!62!     0.000!   -96.000!      0.000!
  A12       !      4!62!     0.000!   -64.000!      0.000!
  ---------------------------------------------------------------------------
  *BOHRKOPF !SPINDEL!WK!DELTA-X   !DELTA-Y   !DURCHMESSER! KOMMENTAR
  ----------+----------+----------+----------+-----------+-------------------
  [V11]
  O11       !     -9!62!     0.000!   -96.000!      0.000!
  O11       !     10!62!     0.000!  -128.000!      5.000!  70.0
  </code></pre>
  
  <p>Questions:
  1. Is it possible to read this and convert as pandas Dataframe? 
  2. Hou to do this ?</p>
  
  <ul>
  <li><em>why pandas dataFrame? I want this data use for some analysis by this characteristics of item. For analysis i always use pandas. Maybe for this i need do different ways ?</em></li>
  </ul>
  
  <p>Expected outpu:</p>
  
  <p>two pandas DataFrames first:</p>
  
  <pre><code>---------------------------------------------------------------------------------------
  *BOHRKOPF !SPINDEL!WK!DELTA-X   !DELTA-Y   !DURCHMESSER! KOMMENTAR ! TYPE
  ----------+----------+----------+----------+-----------+-------------------------------
  A21       !      1!62!     0.000!     0.000!      0.000!           !NoValidForUse
  A12       !     -1!62!     0.000!  -160.000!      0.000!           !V11
  A12       !      2!62!     0.000!  -128.000!      3.000!  70.0     !V11
  A12       !     -3!62!     0.000!   -96.000!      0.000!           !V11
  A12       !      4!62!     0.000!   -64.000!      0.000!           !V11
  </code></pre>
  
  <p>And second:</p>
  
  <pre><code>---------------------------------------------------------------------------------------
  *BOHRKOPF !SPINDEL!WK!DELTA-X   !DELTA-Y   !DURCHMESSER! KOMMENTAR ! TYPE
  ----------+----------+----------+----------+-----------+-------------------------------
  O11       !     -9!62!     0.000!   -96.000!      0.000!           !V11
  O11       !     10!62!     0.000!  -128.000!      5.000!  70.0     !V11
  </code></pre>
  
  <p>Headers of Dataframe1 and dataframe2 can be different:</p>
  
  <pre><code>_MASCHINENNUMMER    : &gt;0-251-11-0950/51&lt;     SACHBEARB.: &gt;BSTWIN32&lt;
  _PRODUKTSCHLUESSEL  : &gt;BST 500&lt;           DATUM     : &gt;05-20-2016&lt;
  ---------------------------------------------------------------------------
  *BOHRKOPF !SPINDEL!WK!DELTA-X   !DELTA-Y   !DURCHMESSER! KOMMENTAR
  ----------+----------+----------+----------+-----------+-------------------
  [NoValidForUse]
  A21       !      1!62!     0.000!     0.000!      0.000!
  [V11]
  A12       !     -1!62!     0.000!  -160.000!      0.000!
  A12       !      2!62!     0.000!  -128.000!      3.000!  70.0
  A12       !     -3!62!     0.000!   -96.000!      0.000!
   ---------------------------------------------------------------------------
  *BOHRKOPF !          !X-POS     !Y-POS     !           ! 
  ----------+----------+----------+----------+-----------+-------------------
  [V11]
  O11       !          !     0.000!   -96.000!           !
  O11       !          !     0.000!  -128.000!           !  
  </code></pre>
  
  <ul>
  <li>on file can be different number of dataframes between 5 and 10 but structure of file sesame separator "!" headers row starts whit "*"</li>
  </ul>