title: Delete a row when a cell is empty
body: <p>I'm trying to delete a row when a cell is empty from the 'calories.xlsx' spreadsheet and send all data, except empty rows, to the 'destination.xlsx' spreadsheet. The code below is how far I got. But still, it does not delete rows that have an empty value based on the calories column.</p>
  <p>This is the data set:</p>
  <p><a href="https://i.stack.imgur.com/RX4V7.png" rel="nofollow noreferrer">Data Set</a></p>
  <p>How can I develop my code to solve this problem?</p>
  <pre><code>import pandas as pd
  
  FileName = 'calories.xlsx'
  SheetName = pd.read_excel(FileName, sheet_name = 'Sheet1')
  
  df = SheetName
  
  print(df)
  
  ListCalories = ['Calories']
  
  print(ListCalories)
  
  for Cell in ListCalories:
      if Cell == 'NaN':
          df.drop[Cell]
  
  print(df)
  
  df.to_excel('destination.xlsx')
  </code></pre>