Наталья's questions

大家好！通过迭代包含组 ID 的列表，编写了一个用于解析 VKontakte 社区的小代码，结果我得到了保存在 csv 文件中的城市和订阅者数量（csv 中的行如下所示：莫斯科，234；列： city, value)，但不保存后续结果。我需要这样的字符串中的结果：

city,value,value,value
Moscow, 234, 587, 321

请告诉我，我该怎么做？？？？我想过做一个循环来增加后续的值，但由于缺乏经验，我什么都想不出来，因为我最近才开始理解编程的基础。请告诉我可以做些什么来解决这个问题？？

csv表的片段：

city,value 
Moscow,586
Kazan,129
Ivanovo,386
Kursk,679
Saratov,231

大家好！你能告诉我如何在csv中对值进行分组吗？我举个例子。csv 文件包含带有城市名称的列： Москва Калининград Курск

您需要获取按列分组的表：

Москва Калининград Курск 
  2         3        1
  3         1        1
  4         2        3
  5         0        0

作为函数执行的结果，我得到以下值：

Москва, 2
Калининград, 3
Курск, 1

我在网上没有找到合适的，但我自己也想不出来（经验和知识不够）。我请求你的帮助！资源：

     import csv 

     with open(f'tmp.csv', 'w') as file:
        writer = csv.writer(file)
        writer.writerow(('Москва','Калининград', 'Курск'))
        
        data = members
        json_str = json.dumps(data)
        resp = json.loads(json_str)

        def count(cities, raw):
            result = {}
            for city in cities:
                result[city] = raw.count(city)
            return result

        data = resp
        raw = []
        uniq_city = set()

        for item in data['items']:
            try:
                city = item['city']['title']
            except KeyError:
                continue
            raw.append(city)
            uniq_city.add(city)
        result = count(uniq_city, raw)

        for key, value in result.items():
            key_city = (f'{key}')
            value_city=(f'{value}')             
            
            with open(f'tmp.csv', 'a', encoding='utf-8', newline='') as file:
                writer = csv.writer(file,delimiter=",",lineterminator="\n")
                if key_city == 'Москва':
                    writer.writerow((value_city))
                elif key_city == 'Калининград':
                    writer.writerow((value_city))             
                elif key_city == 'Курск':
                    writer.writerow((value_city))
                else:
                    pass

我最近才开始研究使用 csv 格式，所以不要严格判断。请告诉我如何对 JSON 数据进行分组并将结果转换为 csv：

1. 从这种格式（指定了csv格式，命令行上不完整显示结果）：
2. 获取这样一个表格（在顶部按城市分组，在左侧 - 通过随机 VKontakte 组，在表格的单元格中 - 来自给定城市的订阅者数量）： 请帮助，我在许多来源中寻找信息，但是，不幸的是，我没有发现任何有价值的东西。我也无法在文档中弄清楚...我将不胜感激！资源：

import auth_vk
import pandas as pd
from pandas import json_normalize
import csv
import json


V = '9.95' # Версия VK API

session = auth_vk.auth_vk_token()
api = vk.API(session, v=V)

def main():

    y = api.groups.getMembers(group_id='rhymes', fields='city') # Id группы
    data = y
    json_str = json.dumps(data)
    resp = json.loads(json_str)
    data_items = str(resp['items'])
    df = json_normalize(resp['items'])
    df.to_csv(r'./out.csv', index=False)

if __name__ == '__main__':
    main()

"id","first.nane","last.nane","can_access_closed","is.closed","city.id","city.title"
71570,"Денис","Сахарных","True","False",60.0,"Казань"
2529981,"Валентин","Шихобалов","True","False",60.0,"Казань"
327738,"Алеся","Тванченко","False","True",1.0,"Москва"
565215,"Дина","Арзамасцева","True","False",60.0,"Казань"
668848,"Алексей","Журавлев","True","False",60.0,"Казань"
691681,"Евгений","Сироткин","True","False",88.0,"Набережные Челны"
864321,"Андрей","Петухов","True","False",60.0,"Казань"
1884663,"Илья","Быков","False","True",60.0,"Казань"
1273782,"Гузель","Габдрахманова","True","False",60.0,"Казань"
1411877,"Сергей","Куранов","True","False",60.0,"Казань"
1446899,"Мария","Рождественская","True","False",,
1864565,"Дмитрий","Спиридонов","True","False",60.0,"Казань"
1888272,"Юлька","Коновалова","True","False",270.0,"Подольск"
1889456,"Алсу","Ситдикова","True","False",60.0,"Казань"
2671147,"Станислав","Каракулов","True","False",,
2112346,"Альбина","Мингазова","False","True",60.0,"Казань"
2138689,"Виктория","Черкесова","True","False",60.0,"Казань"
2146532,"Андрей","Кузнецов","True","False",60.0,"Казань"
2222857,"Юлия","Серегина","True","False",60.0,"Казань"
2241785,"Оля","Карлова","True","False",,
2262812,"Гона","Коган","True","False",60.0,"Казань"
2327792,"Тимур","Камалетдинов","True","False",60.0,"Казань"
2416133,"Марианна","Итанчаева","False","True",60.0,"Казань"
2477628,"Марсель","Миндубаев","False","True",,

您能告诉我如何将 JSON 保存为 CSV 吗？资源：

# -*- coding: utf-8 -*-

#работает с цифровыми и буквенными id 
import vk
import auth_vk
import pandas as pd
from pandas import json_normalize
import csv
import json


V = '9.95' # Версия VK API

session = auth_vk.auth_vk_token()
api = vk.API(session, v=V)

def main():

    y = api.groups.getMembers(group_id='rhymes', fields='city') # Id группы
    data = y
    json_str = json.dumps(data)
    resp = json.loads(json_str)
    data_items = str(resp['items'])
    df = pd.io.json.json_normalize(['items'])
    df.to_csv(r'./out.csv', index=False)

if __name__ == '__main__':
    main()```

При попытке сохранить файл таким методом выдаёт ошибку:
`futurewarning: pandas.io.json.json_normalize`
Подскажите, пожалуйста, как исправить!

您能告诉我如何将执行 def main() 函数的结果定义为变量或将其写入表、文本文件等吗？

def main():
    if len(sys.argv)>1:
        group_id = sys.argv[1]
    else:
        group_id = lst # ввод id групп
        for i, ids in enumerate(group_id):
            members = get_all_members_3(group_id) #ввод айди группы
            for member in members:
                #вывод по городу
                keys = {'title'} #переменная для вывода города
                for citys in member: #цикл для вывода группы
                    for attribute in keys:
                        try:
                            print(member['city']['title'])
                        except KeyError:
                            pass

我对输出结果感兴趣 print(member['city']['title']) 提前感谢您的帮助！