从指定HTML结构的字典列表中提取成绩小数并转换格式的技术需求

Here's a straightforward approach to process your list of dictionaries, extract the grade values, and format them as requested. This solution handles dynamically changing grade numbers and values seamlessly.

Step-by-Step Explanation: #

• Iterate through each dictionary in your input list to access individual student records.
• Identify grade keys: Target keys that start with grade_—these are the fields we need to extract data from.
• Clean the grade value: Strip the percentage sign (%) from the value to isolate the numeric decimal part.
• Format the output string: Construct the desired format (gradeX = numeric_value) where X is the number from the original key (e.g., 1 from grade_1).

Python Code Implementation: #

# Your input dataset
student_data = [
    {'grade_1': '67.81%', 'tag_a_data-analysis': '113087042', 'academic_class': 'Algebra I - 8th Grade - 3 (D)'},
    {'grade_2': '71.88%', 'tag_a_data-analysis': '113087763', 'academic_class': 'Computer Science 8 - 1 (E)'},
    {'grade_3': '82.40%', 'tag_a_data-analysis': '113086978', 'academic_class': 'English 8/Boys - 3 (G)'},
    {'grade_4': '90.77%', 'tag_a_data-analysis': '113087637', 'academic_class': 'Leadership Symphonic Band - 1 (C)'},
    {'grade_7': '90.00%', 'tag_a_data-analysis': '113087376', 'academic_class': 'US History - 6 (H)'}
]

# Process and format grades dynamically
formatted_grades = []
for record in student_data:
    for key, value in record.items():
        if key.startswith('grade_'):
            grade_number = key.split('_')[1]
            cleaned_grade = value.strip('%')
            formatted_grades.append(f"grade{grade_number} = {cleaned_grade}")

# Print the results
for line in formatted_grades:
    print(line)

Output: #

grade1 = 67.81
grade2 = 71.88
grade3 = 82.40
grade4 = 90.77
grade7 = 90.00

This code adapts automatically to any new grade keys (like grade_5 or grade_10) and changing numeric values in your dataset—no hardcoding required.

内容的提问来源于stack exchange，提问作者Jack Underwood