title: How to split data with multiple filters into new file with python
body: <p><a href="https://i.stack.imgur.com/LX7wQ.png" rel="nofollow noreferrer">Excel sheet with multiple filters</a> (see picture)</p>
  <p><a href="https://i.stack.imgur.com/bN8AS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bN8AS.png" alt="enter image description here" /></a></p>
  <p>In the above picture link, we see an excel file with each column presenting a filter. What I'm trying to find out is how can I create a new excel file that still possesses the same columns but with selected filters.</p>
  <p>For example: if I want the new Excel sheet to only show data including &quot;Ewallet&quot; &amp; &quot;Credit card&quot; (under the &quot;Payment&quot; column) and &quot;Yangon&quot; &amp; &quot;Mandalay&quot; (under the &quot;City&quot; column), how would i go by doing this?</p>
  <p><a href="https://i.stack.imgur.com/qlrlm.png" rel="nofollow noreferrer">&quot;City&quot; column filter</a></p>
  <p><a href="https://i.stack.imgur.com/foJGj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/foJGj.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/WmNOK.png" rel="nofollow noreferrer">&quot;Payment&quot; column filter</a></p>
  <p><a href="https://i.stack.imgur.com/uSuvO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uSuvO.png" alt="enter image description here" /></a></p>
  <p>Therefore, the process should be pretty much picking and choosing what filters collectively from each column can be fitted into a single new excel sheet.</p>
  <p>I am trying to do this with openpyxl, xlswings and/ or xlxswriter. I am also pretty new to python code but I do understand code when I read it.</p>
  <p>Thank you</p>