remove_rows_with_no_consensus.py

import pandas as pd

def remove_missing_values(input_csv, output_csv, column_name):
    # Read the CSV file into a DataFrame
    df = pd.read_csv(input_csv)
    
    # Remove rows with missing values in the specified column
    df_cleaned = df.dropna(subset=[column_name])
    
    # Save the cleaned DataFrame back to a CSV file
    df_cleaned.to_csv(output_csv, index=False)

# Example usage
input_csv = './CSP_Rank_Scores/CSP_7jq8_CSpred.csv'
output_csv = input_csv[:-4] + "_clean.csv"
column_name = 'consensus'

remove_missing_values(input_csv, output_csv, column_name)