请问将dataframe切片分别合计后保存到新的csv文件时出现"Name"和“dtype”之类的无用数据如何处理？

Question

import pandas as pd


# 引用
df = pd.read_csv('111.csv')
#按年拆分
grouped = df.groupby('Year')
sumnumber = []
sumlist = []

for i,group in grouped:
#按具体日期拆分（文件内格式为“2025/1/8”）
    yearsdategrouped = group.groupby('Date')
    sumnumber = []
    for j, group1 in yearsdategrouped:
#取每日合计总重
        sumweight = group1['Weight'].sum
#列表包含日期和当日合计总重
        sumnumber.append(group1['Date'])
        sumnumber.append(sumweight)
print(sumnumber)

打印出结果出现异常如下：
,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,731
0,"0 2018-01-01
2557 2018-01-01
5113 2018-01-01
7670 2018-01-01
10227 2018-01-01
12784 2018-01-01
15341 2018-01-01
17898 2018-01-01
20455 2018-01-01
23012 2018-01-01
Name: Date, dtype: datetime64[ns]","<bound method Series.sum of 0 467,411.00
2557 124,243.00
5113 58,289.00
数据后续太多，没都放出来，请问这种情况如何处理？

Answer 1

让【道友老李】来帮你解答，本回答参考gpt编写，并整理提供，如果还有疑问可以点击头像关注私信或评论。

如果答案让您满意，请采纳、关注，非常感谢！

根据您提供的代码和异常，可以看出打印出的结果格式有点混乱，看起来有点乱码，这可能是因为打印出的内容过长导致显示异常。 为了解决这个问题，可以采取以下几种方法：

1. 分批打印：将打印的内容分批进行打印，以便在屏幕上显示完整数据。

for i in range(0, len(sumnumber), 50):
    print(sumnumber[i:i+50])

1. 写入文件：将打印出的结果写入文件，以免内容过长导致显示异常。

with open('output.txt', 'w') as f:
    for item in sumnumber:
        f.write(str(item) + '\n')

1. 精简输出：如果只需要部分数据展示，可以只输出部分数据，而非全部数据。

print(sumnumber[:10])  # 只输出前10条数据

以上是几种处理异常打印结果的方法，您可以根据具体情况选择适合的方法进行处理。