import csv
import json
def write_csv(data, file, encoding="utf-8"):
with open(file, "w", newline="", encoding=encoding) as f1:
fieldnames = data[0].keys()
writer = csv.DictWriter(f1, fieldnames=fieldnames)
writer.writeheader()
writer.writerows(data)
with open('type_info.json', 'r') as f:
data = json.load(f)
write_csv(data, "out.csv", encoding="utf-8")Как вычленить все photo из всех постов макимального размера, т.е. "type": "x" и потом все это добавить в filtered_data ?
max_photos = [att["photo"]["sizes"][-1]["url"] for att in posts["attachments"] if att["type"] == "photo"]Также, пока для меня не понятно, как отсеять рекламные посты? Некоторые посты имеют атрибут "marked_as_ads": 1
In [12]: set([f['country']['title'] for f in friends['items'] if f.get('country')])
Out[12]: {'Belgium', 'Kazakhstan', 'Russia', 'Turkey'}
import pandas as pd
pd.read_csv('in.csv', sep=';', header=None) \
.drop_duplicates(4, keep='first') \
.to_csv('out.csv', header=False, index=False)from functools import lru_cache
@lru_cache(maxsize=None)
def write(unique_field):
fo.write(line)
with open('in.csv', 'r') as fi, open('out.csv', 'w') as fo:
for line in fi:
write(line.rstrip().split(';')[-1])