基于大数据高校新生数据分析系统 -模拟数据

我会带着你远行 2024-05-11 09:24 43阅读 0赞

package com.controller;
    
    import java.io.FileOutputStream;
    import java.io.IOException;
    import java.util.Random;
    import org.apache.poi.ss.usermodel.*;
    import org.apache.poi.xssf.usermodel.XSSFWorkbook;
    
    public class StudentDataGenerator {
    
        private static final String[] GENDERS = {"男", "女"};
        private static final String[] AGE_OPTIONS = {"19岁", "20岁", "21岁", "22岁", "23岁", "24岁"};
        private static final String[] MAJORS = {"计算机科学", "心理学", "化学", "生物学", "经济学", "历史学", "艺术学", "物理学"};
        private static final String[] REGIONS = {"广东省", "北京市", "上海市", "江苏省", "湖北省", "四川省", "浙江省", "河南省"};
        private static final String[] HOBBIES = {"绘画", "音乐", "篮球", "游泳", "登山", "阅读", "写作", "旅行"};
        private static final String[] SOCIAL_ACTIVITIES = {"乐器演奏", "篮球比赛", "志愿者活动", "社交聚会", "户外运动", "音乐会", "舞蹈", "摄影"};
        private static final String[] VOLUNTEER_CHOICES = {"数学分析", "语言学", "社会学", "历史学", "人类学", "物理学", "化学", "生物学"};
        private static final String[] ACADEMIC_INTERESTS = {"神经科学", "人工智能", "量子物理", "环境科学", "社会心理学", "遗传学", "人文地理学", "政治学"};
    
    
        public static void main(String[] args) {
            generateStudentData(1000, "D:/StudentData.xlsx");
        }
    
        private static void generateStudentData(int count, String filePath) {
            try (Workbook workbook = new XSSFWorkbook()) {
                Sheet sheet = workbook.createSheet("Student Data");
                Row headerRow = sheet.createRow(0);
    
                String[] headers = {"年龄", "性别", "学科偏好", "地域", "兴趣爱好", "社交活动", "志愿选择", "学术兴趣"};
                for (int i = 0; i < headers.length; i++) {
                    Cell cell = headerRow.createCell(i);
                    cell.setCellValue(headers[i]);
                }
    
                Random random = new Random();
                for (int i = 0; i < count; i++) {
                    Row row = sheet.createRow(i + 1);
                    row.createCell(0).setCellValue(AGE_OPTIONS[random.nextInt(AGE_OPTIONS.length)]);
                    row.createCell(1).setCellValue(GENDERS[random.nextInt(GENDERS.length)]);
                    row.createCell(2).setCellValue(MAJORS[random.nextInt(MAJORS.length)]);
                    row.createCell(3).setCellValue(REGIONS[random.nextInt(REGIONS.length)]);
                    row.createCell(4).setCellValue(HOBBIES[random.nextInt(HOBBIES.length)]);
                    row.createCell(5).setCellValue(SOCIAL_ACTIVITIES[random.nextInt(SOCIAL_ACTIVITIES.length)]);
                    row.createCell(6).setCellValue(VOLUNTEER_CHOICES[random.nextInt(VOLUNTEER_CHOICES.length)]);
                    row.createCell(7).setCellValue(ACADEMIC_INTERESTS[random.nextInt(ACADEMIC_INTERESTS.length)]);
                }
    
                try (FileOutputStream outputStream = new FileOutputStream(filePath)) {
                    workbook.write(outputStream);
                }
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

![627fe78032764f28a80808b094762045.png][]

[627fe78032764f28a80808b094762045.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/11/980491a246cf46c1a0503c6e0ca8cec1.png