title: How to delete row data from a CSV file using pandas?
body: <p>I am new to Pandas and was wondering how to delete a specific row using the row id. Currently, I have a CSV file that contains data about different students. I do not have any headers in my CSV file. </p>
  
  <p><strong>data.csv:</strong></p>
  
  <pre><code>John    21 34 87 ........ #more than 100 columns of data
  Abigail 18 45 53 ........ #more than 100 columns of data
  Norton  19 45 12 ........ #more than 100 columns of data
  </code></pre>
  
  <p><strong>data.py:</strong></p>
  
  <p>I have a list that has a record of some names.</p>
  
  <pre><code>names = ['Jonathan', 'Abigail', 'Cassandra', 'Ezekiel']
  </code></pre>
  
  <p>I opened my CSV file in Python and used list comprehension in order to read all the names in the first column and store them in a list with a variable 'student_list' assigned.</p>
  
  <p>Now, for all elements in the student_list, if the element is not seen in the <strong>'names'</strong> list, I want to delete that element in my CSV file. In this example, I want to delete John and Norton since they do not appear in the names list. How can I achieve this using pandas? Or, is there a better alternative out there than compared to using pandas for this problem?</p>
  
  <p>I have tried the following code below:</p>
  
  <pre><code>csv_filename = data.csv
      with open(csv_filename, 'r') as readfile:
          reader = csv.reader(readfile, delimiter=',') 
          student_list = [row[0] for row in reader]  #returns John, Abigail and Norton.
  
          for student in student_list:
          if student not in names:
              id = student_list.index(student) #grab the index of the student in student list who's not found in the names list.
  
              #using pandas
              df = pd.read_csv(csv_filename) #read data.csv file
              df.drop(df.index[id], in_place = True) #delete the row id for the student who does not exist in names list.
              df.to_csv(csv_filename, index = False, sep=',')  #close the csv file with no index
          else:
              print("Student name found in names list")
  </code></pre>
  
  <p>I am not able to delete the data properly. Can anybody explain?</p>