以下是一个使用 Java 来解决此问题的示例代码,同时也提供了 `pom.xml` 文件: ```java import org.apache.commons.csv.CSVFormat; import org.apache.commons.csv.CSVRecord; import java.io.FileReader; import java.io.IOException; import java.io.Reader; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.*; public class StockAnalysis { public static void main(String[] args) { String filePath = "stocks.csv"; Map<String, MonthlyStockData> monthlyDataMap = new HashMap<>(); try (Reader reader = new FileReader(filePath)) { Iterable<CSVRecord> records = CSVFormat.DEFAULT.withHeader().parse(reader); for (CSVRecord record : records) { String tradeDate = record.get("trade_date"); double open = Double.parseDouble(record.get("open")); double high = Double.parseDouble(record.get("high")); double low = Double.parseDouble(record.get("low")); double close = Double.parseDouble(record.get("close")); double amount = Double.parseDouble(record.get("amount")); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM"); String month = sdf.format(sdf.parse(tradeDate)); if (!monthlyDataMap.containsKey(month)) { monthlyDataMap.put(month, new MonthlyStockData()); } MonthlyStockData monthlyData = monthlyDataMap.get(month); monthlyData.updateData(close, amount, high, low); } } catch (IOException | ParseException e) { e.printStackTrace(); } for (Map.Entry<String, MonthlyStockData> entry : monthlyDataMap.entrySet()) { String month = entry.getKey(); MonthlyStockData data = entry.getValue(); System.out.printf("%s %.2f - %.2f %.2f%% %.2f%n", month, data.getLow(), data.getHigh(), data.getVolatility(), data.getTotalAmount()); } } static class MonthlyStockData { private double high; private double low; private double totalAmount; private double totalClose; private int count; public void updateData(double close, double amount, double high, double low) { this.high = Math.max(this.high, high); this.low = Math.min(this.low, low); this.totalAmount += amount; this.totalClose += close; this.count++; } public double getHigh() { return high; } public double getLow() { return low; } public double getAverageClose() { return totalClose / count; } public double getVolatility() { double range = high - low; double average = getAverageClose(); return (range / average) * 100; } public double getTotalAmount() { return totalAmount; } } } ``` `pom.xml` 文件内容如下: ```xml <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.example</groupId> <artifactId>stock-analysis</artifactId> <version>1.0-SNAPSHOT</version> <dependencies> <dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-csv</artifactId> <version>1.9</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>3.8.1</version> <configuration> <source>1.8</source> <target>1.8</target> </configuration> </plugin> </plugins> </build> </project> ``` 上述代码假设 `stocks.csv` 文件中的交易日期格式为 `yyyy-MM-dd` ,并且在实际运行时请根据您的文件路径修改代码中的 `filePath` 变量。 [2024-11-13 14:46:13 | AI写代码神器 | 1052点数解答]