/
lemut
/
cifranet
Обзор
Документация
Войти
/
lemut
/
cifranet
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
connected.py
48 строк
1 KB
lemut
first_commit
23 июл 2026, 11:49
23 июл 2026, 11:49
910f940
Код
Авторство
О чём код?
import pandas as pd import numpy as np from pathlib import Path import xlrd DATA_FAREAST='/home/RUGRID.RU/lemtyugin-ai/py/graf/data/connected_objects_fareast.xlsx' FAREAST = pd.read_excel(DATA_FAREAST) OBJECTS = [OBJECTS for OBJECTS in FAREAST['object_name'].unique() if OBJECTS != ''] for OBJECTS in OBJECTS: print (OBJECTS) FAREAST_FILTRED = FAREAST.query("spd_router_name == 'crt2-ne20e.amurskaya.fareast.etsse'") print(FAREAST_FILTRED) unique_values = FAREAST_FILTRED['object_name'].unique() print (unique_values) print (len(unique_values)) DATA_LOAD = '' PREFIX_SUM_TC=0 for child in Path('/home/RUGRID.RU/lemtyugin-ai/py/graf/data_connected/').iterdir(): if child.is_file(): print (child) READ_FILE = pd.read_excel(child, sheet_name='Policies-in') FILTRED_TC_PREFIX = READ_FILE.query("vrf == 'TC'") unique_values = FILTRED_TC_PREFIX['allow_subnet_in'].unique() PREFIX_SUM_TC=PREFIX_SUM_TC+len(unique_values) print (len(unique_values)) print ("Prefix TC: " + str(PREFIX_SUM_TC)) PREFIX_SUM_CORP=0 for child in Path('/home/RUGRID.RU/lemtyugin-ai/py/graf/data_connected/').iterdir(): if child.is_file(): print (child) READ_FILE = pd.read_excel(child, sheet_name='Policies-in') FILTRED_CORP_PREFIX = READ_FILE.query("vrf == 'CORP'") unique_values = FILTRED_CORP_PREFIX['allow_subnet_in'].unique() PREFIX_SUM_CORP=PREFIX_SUM_CORP+len(unique_values) print (len(unique_values)) print ("Prefix CORP: " + str(PREFIX_SUM_CORP))