title: filter excel data with python pandas
body: <p><a href="https://i.stack.imgur.com/5BdFm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5BdFm.png" alt="enter image description here"></a></p>
  
  <p>I want to filter out country belonging to the tuple <strong>need</strong> and display every data in the records for countries after filter...</p>
  
  <pre><code>import pandas as pd
  import os
  import xlwt
  import xlrd
  
  
  file = 'ida.xlsx'
  data = pd.read_excel(file)
  need =("Algeria", "Angola", "Argentina", "Bangladesh", "Belize", "Benin", "Bhutan", "Bolivia", "Botswana", "Brazil", "Burkina Faso", "Burundi", 
  "Cameroon", "Cape Verde", "Central African Rep.", "Chad", "Chile", "China", "Colombia", "Comoros", "Congo, Dem. Rep.", "Congo, Republic", 
  "Costa Rica", "Cote d'Ivoire", "Cuba", "Djibouti", "Dominica", "Dominican Republic", "Ecuador", "Egypt", "El Salvador", "Equatorial Guinea", "Ethiopia", "Fiji", "Gabon", "Gambia", "Ghana", "Grenada", "Guatemala", "Guinea", "Guinea-Bissau", "Guyana", "Haiti", "Honduras", 
  "India", "Indonesia", "Iran", "Jamaica", "Jordan", "Kenya", "Kiribati", "Kyrgyzstan", "Laos", "Lebanon", "Lesotho", "Madagascar", "Malawi", 
  "Malaysia", "Maldives", "Mali", "Marshall Island", "Mauritania", "Mauritius", "Mexico", "Mongolia", "Morocco", "Mozambique", "Myanmar", 
  "Namibia", "Nepal", "Nicaragua", "Niger", "Pakistan", "Panama", "Papua New Guinea", "Paraguay", "Peru", "Philippines", "Rwanda", "Samoa", 
  "Sao Tome and Principe", "Senegal", "Seychelles", "Sierra Leone", "Solomon Islands", "South Africa", "Sri Lanka", "St Vincent and the Grenadines", "St.Kitts", "St.Lucia", "Sudan", "Suriname", "Swaziland", "Tanzania", "Thailand", "Togo", "Tonga", "Tunisia", "Turkey", 
  "Uganda", "Uruguay", "Vanuatu", "Venezuela", "Viet Nam", "Zambia", "Zimbabwe")
  for i in data.index:
      filt = data[data['Recipient'][i] == need]
      print(filt)
  </code></pre>
  
  <p>i get 
  .</p>
  
  <blockquote>
    <blockquote>
      <blockquote>
        <p>============== RESTART: C:/Users/robinson/Desktop/next set/done.py =============
        Empty DataFrame
        Columns: [Recipient, Unnamed: 1, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018]
        Index: []</p>
        
        <p>instead of data of each country and year... </p>
      </blockquote>
    </blockquote>
  </blockquote>