RError.com

RError.com Logo RError.com Logo

RError.com Navigation

  • 主页

Mobile menu

Close
  • 主页
  • 系统&网络
    • 热门问题
    • 最新问题
    • 标签
  • Ubuntu
    • 热门问题
    • 最新问题
    • 标签
  • 帮助
主页 / user-589230

Филипп Шувалов's questions

Martin Hope
Филипп Шувалов
Asked: 2025-04-29 18:15:51 +0000 UTC

CadQuery python:构建对象的复杂倒角

  • 8

尝试在 CadQuery Python 中对螺栓进行建模:

import cadquery as cq
from math import sqrt, tan, radians

# Параметры модели
head_diameter = 10.0  # Диаметр по вершинам (описанная окружность)
head_height = 5.0     # Высота головки
shaft_diameter = 5.0  # Диаметр стержня
shaft_length = 20.0   # Длина стержня

# Расчетные параметры
R = head_diameter / 2                 # Радиус описанной окружности
r = R * sqrt(3)/2                     # Радиус вписанной окружности
chamfer_size = (R - r) / tan(45)      # Размер фаски для угла 45°

#1. Создаем шестигранную головку
bolt_head = (
    cq.Workplane("XY")
    .polygon(6, 2*R)                  # Создаем шестигранник
    .extrude(head_height)              # Выдавливаем на высоту головки
    .translate((0, 0, -1 * (head_height/2)))
)

bolt_head = bolt_head.edges("Z").chamfer(1)

# 2. Создаем стержень
bolt_shaft = (
    cq.Workplane("XY")
    .circle(shaft_diameter/2)
    .extrude(-shaft_length)
)

# 3. Объединяем компоненты
bolt = bolt_head.union(bolt_shaft)

结果是这样的胡言乱语: 在此处输入图片描述

现在的问题是。如何以 45 度角切割螺栓头的顶角。目标是得到像这样的螺栓头: 在此处输入图片描述

python
  • 2 个回答
  • 49 Views
Martin Hope
Филипп Шувалов
Asked: 2024-06-14 21:41:51 +0000 UTC

Python,Pandas删除数据列并插入空行

  • 5

我遇到一个问题:创建数据框时,pandas 删除包含数据的一列并插入包含空值的第二行。如何修复它?

import pandas as pd
import json
from io import StringIO
        
List_Objects = [{'CadastralNumber': '37:24:01024'},
                        {'DateCreated': '2011-12-09+04:00'},
                        {'FoundationDate': ''},
                        {'Area': '5462'},
                        {'AssignationBuilding': '204003000000'},
                        {'CadastralBlock': '37:24:010246'},
                        {'CadastralCost': ''},
                        {'CadastralCost_Value': '163292388.96'},
                        {'CadastralCost/ApplicationDate': ''},
                        {'CadastralCost/ApplicationLastDate': ''},
                        {'CadastralCost/ApprovalDocument': ''},
                        {'CadastralCost/ApprovalDocument/CodeDocument': ''},
                        {'CadastralCost/ApprovalDocument/Date': ''},
                        {'CadastralCost/ApprovalDocument/Desc': ''},
                        {'CadastralCost/ApprovalDocument/IssueOrgan': ''},
                        {'CadastralCost/ApprovalDocument/Name': ''},
                        {'CadastralCost/ApprovalDocument/Number': ''},
                        {'CadastralCost/ApprovalDocument/Series': ''},
                        {'CadastralCost/DateApproval': '2012-09-27+04:00'},
                        {'CadastralCost/DateEntering': '2012-10-09+04:00'},
                        {'CadastralCost/DateValuation': '2011-12-10+04:00'},
                        {'CadastralCost/RevisalStatementDate': ''},
                        {'CarParkingSpacesCadastralNumbers': ''},
                        {'CarParkingSpacesCadastralNumbers/CadastralNumber': ''},
                        {'CulturalHeritage': ''},
                        {'CulturalHeritage/AssignmentEGROKN': ''},
                        {'CulturalHeritage/AssignmentEGROKN/NameCultural': ''},
                        {'CulturalHeritage/AssignmentEGROKN/ObjCultural': ''},
                        {'CulturalHeritage/AssignmentEGROKN/RegNum': ''},
                        {'CulturalHeritage/Document': ''},
                        {'CulturalHeritage/Document/CodeDocument': ''},
                        {'CulturalHeritage/Document/Date': ''},
                        {'CulturalHeritage/Document/Desc': ''},
                        {'CulturalHeritage/Document/IssueOrgan': ''},
                        {'CulturalHeritage/Document/Name': ''},
                        {'CulturalHeritage/Document/Number': ''},
                        {'CulturalHeritage/Document/Series': ''},
                        {'CulturalHeritage/InclusionEGROKN': ''},
                        {'CulturalHeritage/InclusionEGROKN/NameCultural': ''},
                        {'CulturalHeritage/InclusionEGROKN/ObjCultural': ''},
                        {'CulturalHeritage/InclusionEGROKN/RegNum': ''},
                        {'CulturalHeritage/RequirementsEnsure': ''},
                        {'ElementsConstruct': ''},
                        {'ElementsConstruct/Material': None},
                        {'ElementsConstruct/Material_Wall': '061001007001'},
                        {'ExploitationChar': None},
                        {'ExploitationChar_YearBuilt': '1978'},
                        {'ExploitationChar_YearUsed': ''},
                        {'FacilityCadastralNumber': ''},
                        {'FacilityCadastralNumber/CadastralNumber': ''},
                        {'FacilityCadastralNumber/Name': ''},
                        {'FacilityCadastralNumber/Purpose': ''},
                        {'FlatsCadastralNumbers': ''},
                        {'FlatsCadastralNumbers/CadastralNumber': '37:24'},
                        {'Floors': None},
                        {'Floors_Floors': '6'},
                        {'Floors_UndergroundFloors': '1'},
                        {'Location': ''},
                        {'Location_AddressOrLocation': ''},
                        {'Location/Apartment': ''},
                        {'Location/Apartment_Type': ''},
                        {'Location/Apartment_Value': ''},
                        {'Location/City': None},
                        {'Location/City_Name': 'Иваново'},
                        {'Location/City_Type': 'Г'},
                        {'Location/District': ''},
                        {'Location/District_Name': ''},
                        {'Location/District_Type': ''},
                        {'Location/FIAS': ''},
                        {'Location/KLADR': '37000001000074600'},
                        {'Location/Level1': None},
                        {'Location/Level1_Type': 'Д.'},
                        {'Location/Level1_Value': '35'},
                        {'Location/Level2': ''},
                        {'Location/Level2_Type': ''},
                        {'Location/Level2_Value': ''},
                        {'Location/Level3': ''},
                        {'Location/Level3_Type': ''},
                        {'Location/Level3_Value': ''},
                        {'Location/Locality': ''},
                        {'Location/Locality_Name': ''},
                        {'Location/Locality_Type': ''},
                        {'Location/Note': ''},
                        {'Location/OKATO': '24401000000'},
                        {'Location/OKTMO': ''},
                        {'Location/Other': ''},
                        {'Location/PostalCode': ''},
                        {'Location/ReadableAddress': ''},
                        {'Location/Region': '37'},
                        {'Location/RussianFederation': 'Российская Федерация'},
                        {'Location/SovietVillage': ''},
                        {'Location/SovietVillage_Name': ''},
                        {'Location/SovietVillage_Type': ''},
                        {'Location/Street': None},
                        {'Location/Street_Name': ''},
                        {'Location/Street_Type': 'Ул'},
                        {'Location/UrbanDistrict': ''},
                        {'Location/UrbanDistrict_Name': ''},
                        {'Location/UrbanDistrict_Type': ''},
                        {'Name': 'Многоквартирный Дом'},
                        {'ObjectPermittedUses': ''},
                        {'ObjectPermittedUses/ObjectPermittedUse': ''},
                        {'ObjectType': '002001002000'},
                        {'ParentCadastralNumbers': ''},
                        {'ParentCadastralNumbers/CadastralNumber': '37:24:010'},
                        {'PrevCadastralNumbers': ''},
                        {'PrevCadastralNumbers/CadastralNumber': ''},
                        {'PreviouslyPosted': 'True'},
                        {'SubBuildings': ''},
                        {'SubBuildings/SubBuilding': ''},
                        {'SubBuildings/SubBuilding_NumberRecord': ''},
                        {'SubBuildings/SubBuilding_DateCreated': ''},
                        {'SubBuildings/SubBuilding/Area': ''},
                        {'SubBuildings/SubBuilding/Encumbrances': ''},
                        {'SubBuildings/SubBuilding/Encumbrances/Document': ''},
                        {'SubBuildings/SubBuilding/Encumbrances/Document/CodeDocument': ''},
                        {'SubBuildings/SubBuilding/Encumbrances/Document/Date': ''},
                        {'SubBuildings/SubBuilding/Encumbrances/Document/Desc': ''},
                        {'SubBuildings/SubBuilding/Encumbrances/Document/IssueOrgan': ''},
                        {'SubBuildings/SubBuilding/Encumbrances/Document/Name': ''},
                        {'SubBuildings/SubBuilding/Encumbrances/Document/Number': ''},
                        {'SubBuildings/SubBuilding/Encumbrances/Document/Series': ''},
                        {'SubBuildings/SubBuilding/Encumbrances/Name': ''},
                        {'SubBuildings/SubBuilding/Encumbrances/Registration': ''},
                        {'SubBuildings/SubBuilding/Encumbrances/Registration/RegistrationDate': ''},
                        {'SubBuildings/SubBuilding/Encumbrances/Registration/RightNumber': ''},
                        {'SubBuildings/SubBuilding/Encumbrances/Type': ''},
                        {'UnitedCadastralNumber': ''},
                        {'UnitedCadastralNumber/CadastralNumber': ''},
                        {'UnitedCadastralNumber/Name': ''},
                        {'UnitedCadastralNumber/Purpose': ''},
                        {'CadastralNumberOKS': ''},
                        {'ParentOKS': ''},
                        {'ParentOKS/AssignationBuilding': ''},
                        {'ParentOKS/AssignationName': ''},
                        {'ParentOKS/CadastralNumberOKS': ''},
                        {'ParentOKS/ElementsConstruct': ''},
                        {'ParentOKS/ElementsConstruct/Material': ''},
                        {'ParentOKS/ElementsConstruct/Material_Wall': ''},
                        {'ParentOKS/ExploitationChar': ''},
                        {'ParentOKS/ExploitationChar_YearBuilt': ''},
                        {'ParentOKS/ExploitationChar_YearUsed': ''},
                        {'ParentOKS/Floors': ''},
                        {'ParentOKS/Floors_Floors': ''},
                        {'ParentOKS/Floors_UndergroundFloors': ''},
                        {'ParentOKS/ObjectType': ''},
                        {'PositionInObject': ''},
                        {'PositionInObject_Number': ''},
                        {'PositionInObject_Type': ''},
                        {'PositionInObject/Position': ''},
                        {'PositionInObject/Position_NumberOnPlan': ''},
                        {'PositionInObject/Position_Description': ''},
                        {'AssignationName': ''},
                        {'KeyParameters': ''},
                        {'KeyParameters/KeyParameter': ''},
                        {'KeyParameters/KeyParameter_Type': ''},
                        {'KeyParameters/KeyParameter_Value': ''},
                        {'SubConstructions': ''},
                        {'SubConstructions/SubConstruction': ''},
                        {'SubConstructions/SubConstruction_NumberRecord': ''},
                        {'SubConstructions/SubConstruction_DateCreated': ''},
                        {'SubConstructions/SubConstruction/Encumbrances': ''},
                        {'SubConstructions/SubConstruction/Encumbrances/Document': ''},
                        {'SubConstructions/SubConstruction/Encumbrances/Document/CodeDocument': ''},
                        {'SubConstructions/SubConstruction/Encumbrances/Document/Date': ''},
                        {'SubConstructions/SubConstruction/Encumbrances/Document/Desc': ''},
                        {'SubConstructions/SubConstruction/Encumbrances/Document/IssueOrgan': ''},
                        {'SubConstructions/SubConstruction/Encumbrances/Document/Name': ''},
                        {'SubConstructions/SubConstruction/Encumbrances/Document/Number': ''},
                        {'SubConstructions/SubConstruction/Encumbrances/Document/Series': ''},
                        {'SubConstructions/SubConstruction/Encumbrances/Name': ''},
                        {'SubConstructions/SubConstruction/Encumbrances/Registration': ''},
                        {'SubConstructions/SubConstruction/Encumbrances/Registration/RegistrationDate': ''},
                        {'SubConstructions/SubConstruction/Encumbrances/Registration/RightNumber': ''},
                        {'SubConstructions/SubConstruction/Encumbrances/Type': ''},
                        {'SubConstructions/SubConstruction/KeyParameter': ''},
                        {'SubConstructions/SubConstruction/KeyParameter_Type': ''},
                        {'SubConstructions/SubConstruction/KeyParameter_Value': ''},
                        {'Assignation': ''},
                        {'Assignation/AssignationCode': ''},
                        {'Assignation/AssignationType': ''},
                        {'Assignation/AuxiliaryFlat': ''},
                        {'Assignation/SpecialType': ''},
                        {'Assignation/TotalAssets': ''},
                        {'CadastralNumberFlat': ''},
                        {'Location/RoomNumber': ''},
                        {'PositionInObject': ''},
                        {'PositionInObject/Level': ''},
                        {'PositionInObject/Level_Number': ''},
                        {'PositionInObject/Level_Type': ''},
                        {'PositionInObject/Level/Position': ''},
                        {'PositionInObject/Level/Position_NumberOnPlan': ''},
                        {'PositionInObject/Level/Position_Description': ''},
                        {'SubFlats': ''},
                        {'SubFlats/SubFlat': ''},
                        {'SubFlats/SubFlat_NumberRecord': ''},
                        {'SubFlats/SubFlat_DateCreated': ''},
                        {'SubFlats/SubFlat/Area': ''},
                        {'SubFlats/SubFlat/Encumbrances': ''},
                        {'SubFlats/SubFlat/Encumbrances/Document': ''},
                        {'SubFlats/SubFlat/Encumbrances/Document/CodeDocument': ''},
                        {'SubFlats/SubFlat/Encumbrances/Document/Date': ''},
                        {'SubFlats/SubFlat/Encumbrances/Document/Desc': ''},
                        {'SubFlats/SubFlat/Encumbrances/Document/IssueOrgan': ''},
                        {'SubFlats/SubFlat/Encumbrances/Document/Name': ''},
                        {'SubFlats/SubFlat/Encumbrances/Document/Number': ''},
                        {'SubFlats/SubFlat/Encumbrances/Document/Series': ''},
                        {'SubFlats/SubFlat/Encumbrances/Name': ''},
                        {'SubFlats/SubFlat/Encumbrances/Registration': ''},
                        {'SubFlats/SubFlat/Encumbrances/Registration/RegistrationDate': ''},
                        {'SubFlats/SubFlat/Encumbrances/Registration/RightNumber': ''},
                        {'SubFlats/SubFlat/Encumbrances/Type': ''},
                        {'DegreeReadiness': ''}]
        
        
        
        
json_data = json.dumps(List_Objects)
df = pd.read_json(StringIO(json_data))
df = df.apply(lambda x: pd.Series(x.dropna().values))
print(df)
print(len(List_Objects))
    
     CadastralNumber  ... DegreeReadiness
 0  37:24:010246:397  ...                
 1               NaN  ...             NaN
        
[2 rows x 212 columns]
 213
        
Process finished with exit code 0
python
  • 1 个回答
  • 20 Views
Martin Hope
Филипп Шувалов
Asked: 2024-05-08 17:33:34 +0000 UTC

Python代码优化和递归

  • 5

有一个源列表,它是 XML 文档中嵌套标签的结构:

some_list = ['CadastralBlock', ['ParentCadastralNumbers', ['CadastralNumber']], ['PrevCadastralNumbers', ['CadastralNumber']], 'PreviouslyPosted', 'Name', 'ObjectType', 'AssignationBuilding', ['ElementsConstruct', ['Material']], 'ExploitationChar', 'Floors', 'Area', ['Location', ['FIAS', 'OKATO', 'KLADR', 'OKTMO', 'PostalCode', 'RussianFederation', 'Region', 'District', 'City', 'UrbanDistrict', 'SovietVillage', 'Locality', 'Street', 'Level1', 'Level2', 'Level3', 'Apartment', 'Other', 'Note', 'ReadableAddress']], ['ObjectPermittedUses', ['ObjectPermittedUse']], ['CadastralCost', ['DateValuation', 'DateEntering', 'DateApproval', 'ApplicationDate', 'RevisalStatementDate', 'ApplicationLastDate', ['ApprovalDocument', ['CodeDocument', 'Name', 'Series', 'Number', 'Date', 'IssueOrgan', 'Desc']]]], ['SubBuildings', [['SubBuilding', ['Area', ['Encumbrances', ['Name', 'Type', ['Registration', ['RightNumber', 'RegistrationDate']], ['Document', ['CodeDocument', 'Name', 'Series', 'Number', 'Date', 'IssueOrgan', 'Desc']]]]]]]], ['FlatsCadastralNumbers', ['CadastralNumber']], ['CarParkingSpacesCadastralNumbers', ['CadastralNumber']], ['UnitedCadastralNumber', ['CadastralNumber', 'Purpose', 'Name']], ['FacilityCadastralNumber', ['CadastralNumber', 'Purpose', 'Name']], ['CulturalHeritage', [['InclusionEGROKN', ['RegNum', 'ObjCultural', 'NameCultural']], ['AssignmentEGROKN', ['RegNum', 'ObjCultural', 'NameCultural']], 'RequirementsEnsure', ['Document', ['CodeDocument', 'Name', 'Series', 'Number', 'Date', 'IssueOrgan', 'Desc']]]]]

我编写了一个函数,一个初始列表 some_list 的处理程序,它以线性序列显示标签的结构:

def process_list(lst):  
    for i in lst:
        if isinstance(i, str):
            print(i)
        elif isinstance(i, list):
            if len(i) > 1 and isinstance(i[1], list):
                for item in i[1]:
                    if isinstance(item, list):
                        for subitem in item[1]:
                            if isinstance(subitem, list):
                                for subsubitem in subitem[1]:
                                    if isinstance(subsubitem, list):
                                        for subsubsubitem in subsubitem[1]:
                                            print(i[0], item[0], subitem[0], subsubitem[0], subsubsubitem)
                                    else:
                                        print(i[0], item[0], subitem[0], subsubitem)
                            else:
                                print(i[0], item[0], subitem)
                    else:
                        print(i[0], item)
            else:
                print(i[0])


process_list(some_list)

process_list()函数的输出如下:

CadastralBlock
ParentCadastralNumbers CadastralNumber
PrevCadastralNumbers CadastralNumber
PreviouslyPosted
Name
ObjectType
AssignationBuilding
ElementsConstruct Material
ExploitationChar
Floors
Area
Location FIAS
Location OKATO
Location KLADR
Location OKTMO
Location PostalCode
Location RussianFederation
Location Region
Location District
Location City
Location UrbanDistrict
Location SovietVillage
Location Locality
Location Street
Location Level1
Location Level2
Location Level3
Location Apartment
Location Other
Location Note
Location ReadableAddress
ObjectPermittedUses ObjectPermittedUse
CadastralCost DateValuation
CadastralCost DateEntering
CadastralCost DateApproval
CadastralCost ApplicationDate
CadastralCost RevisalStatementDate
CadastralCost ApplicationLastDate
CadastralCost ApprovalDocument CodeDocument
CadastralCost ApprovalDocument Name
CadastralCost ApprovalDocument Series
CadastralCost ApprovalDocument Number
CadastralCost ApprovalDocument Date
CadastralCost ApprovalDocument IssueOrgan
CadastralCost ApprovalDocument Desc
SubBuildings SubBuilding Area
SubBuildings SubBuilding Encumbrances Name
SubBuildings SubBuilding Encumbrances Type
SubBuildings SubBuilding Encumbrances Registration RightNumber
SubBuildings SubBuilding Encumbrances Registration RegistrationDate
SubBuildings SubBuilding Encumbrances Document CodeDocument
SubBuildings SubBuilding Encumbrances Document Name
SubBuildings SubBuilding Encumbrances Document Series
SubBuildings SubBuilding Encumbrances Document Number
SubBuildings SubBuilding Encumbrances Document Date
SubBuildings SubBuilding Encumbrances Document IssueOrgan
SubBuildings SubBuilding Encumbrances Document Desc
FlatsCadastralNumbers CadastralNumber
CarParkingSpacesCadastralNumbers CadastralNumber
UnitedCadastralNumber CadastralNumber
UnitedCadastralNumber Purpose
UnitedCadastralNumber Name
FacilityCadastralNumber CadastralNumber
FacilityCadastralNumber Purpose
FacilityCadastralNumber Name
CulturalHeritage InclusionEGROKN RegNum
CulturalHeritage InclusionEGROKN ObjCultural
CulturalHeritage InclusionEGROKN NameCultural
CulturalHeritage AssignmentEGROKN RegNum
CulturalHeritage AssignmentEGROKN ObjCultural
CulturalHeritage AssignmentEGROKN NameCultural
CulturalHeritage RequirementsEnsure
CulturalHeritage Document CodeDocument
CulturalHeritage Document Name
CulturalHeritage Document Series
CulturalHeritage Document Number
CulturalHeritage Document Date
CulturalHeritage Document IssueOrgan
CulturalHeritage Document Desc

process_list() 函数很可能无法提供问题的最佳解决方案。假设 some_list 结构的深度未知,如何对其进行优化并使其递归?

python
  • 2 个回答
  • 50 Views
Martin Hope
Филипп Шувалов
Asked: 2024-04-19 18:24:05 +0000 UTC

处理嵌套字典时,某些嵌套键不显示

  • 5
some_dict = {'tag': 'Building', 'attrib': ['CadastralNumber', 'DateCreated', 'FoundationDate'], 'CadastralBlock': {'tag': 'CadastralBlock', 'attrib': []}, 'ParentCadastralNumbers': {'tag': 'ParentCadastralNumbers', 'attrib': [], 'CadastralNumber': {'tag': 'CadastralNumber', 'attrib': []}}, 'PrevCadastralNumbers': {'tag': 'PrevCadastralNumbers', 'attrib': [], 'CadastralNumber': {'tag': 'CadastralNumber', 'attrib': []}}, 'PreviouslyPosted': {'tag': 'PreviouslyPosted', 'attrib': []}, 'Name': {'tag': 'Name', 'attrib': []}, 'ObjectType': {'tag': 'ObjectType', 'attrib': []}, 'AssignationBuilding': {'tag': 'AssignationBuilding', 'attrib': []}, 'ElementsConstruct': {'tag': 'ElementsConstruct', 'attrib': [], 'Material': {'tag': 'Material', 'attrib': ['Wall']}}, 'ExploitationChar': {'tag': 'ExploitationChar', 'attrib': ['YearBuilt', 'YearUsed']}, 'Floors': {'tag': 'Floors', 'attrib': ['Floors', 'UndergroundFloors']}, 'Area': {'tag': 'Area', 'attrib': []}, 'Location': {'tag': 'Location', 'attrib': ['AddressOrLocation'], 'FIAS': {'tag': 'FIAS', 'attrib': []}, 'OKATO': {'tag': 'OKATO', 'attrib': []}, 'KLADR': {'tag': 'KLADR', 'attrib': []}, 'OKTMO': {'tag': 'OKTMO', 'attrib': []}, 'PostalCode': {'tag': 'PostalCode', 'attrib': []}, 'RussianFederation': {'tag': 'RussianFederation', 'attrib': []}, 'Region': {'tag': 'Region', 'attrib': []}, 'District': {'tag': 'District', 'attrib': ['Name', 'Type']}, 'City': {'tag': 'City', 'attrib': ['Name', 'Type']}, 'UrbanDistrict': {'tag': 'UrbanDistrict', 'attrib': ['Name', 'Type']}, 'SovietVillage': {'tag': 'SovietVillage', 'attrib': ['Name', 'Type']}, 'Locality': {'tag': 'Locality', 'attrib': ['Name', 'Type']}, 'Street': {'tag': 'Street', 'attrib': ['Name', 'Type']}, 'Level1': {'tag': 'Level1', 'attrib': ['Type', 'Value']}, 'Level2': {'tag': 'Level2', 'attrib': ['Type', 'Value']}, 'Level3': {'tag': 'Level3', 'attrib': ['Type', 'Value']}, 'Apartment': {'tag': 'Apartment', 'attrib': ['Type', 'Value']}, 'Other': {'tag': 'Other', 'attrib': []}, 'Note': {'tag': 'Note', 'attrib': []}, 'ReadableAddress': {'tag': 'ReadableAddress', 'attrib': []}}, 'ObjectPermittedUses': {'tag': 'ObjectPermittedUses', 'attrib': [], 'ObjectPermittedUse': {'tag': 'ObjectPermittedUse', 'attrib': []}}, 'CadastralCost': {'tag': 'CadastralCost', 'attrib': ['Value'], 'DateValuation': {'tag': 'DateValuation', 'attrib': []}, 'DateEntering': {'tag': 'DateEntering', 'attrib': []}, 'DateApproval': {'tag': 'DateApproval', 'attrib': []}, 'ApplicationDate': {'tag': 'ApplicationDate', 'attrib': []}, 'RevisalStatementDate': {'tag': 'RevisalStatementDate', 'attrib': []}, 'ApplicationLastDate': {'tag': 'ApplicationLastDate', 'attrib': []}, 'ApprovalDocument': {'tag': 'ApprovalDocument', 'attrib': [], 'CodeDocument': {'tag': 'CodeDocument', 'attrib': []}, 'Name': {'tag': 'Name', 'attrib': []}, 'Series': {'tag': 'Series', 'attrib': []}, 'Number': {'tag': 'Number', 'attrib': []}, 'Date': {'tag': 'Date', 'attrib': []}, 'IssueOrgan': {'tag': 'IssueOrgan', 'attrib': []}, 'Desc': {'tag': 'Desc', 'attrib': []}}}, 'SubBuildings': {'tag': 'SubBuildings', 'attrib': [], 'SubBuilding': {'tag': 'SubBuilding', 'attrib': ['NumberRecord', 'DateCreated'], 'Area': {'tag': 'Area', 'attrib': []}, 'Encumbrances': {'tag': 'Encumbrances', 'attrib': [], 'Name': {'tag': 'Name', 'attrib': []}, 'Type': {'tag': 'Type', 'attrib': []}, 'Registration': {'tag': 'Registration', 'attrib': [], 'RightNumber': {'tag': 'RightNumber', 'attrib': []}, 'RegistrationDate': {'tag': 'RegistrationDate', 'attrib': []}}, 'Document': {'tag': 'Document', 'attrib': [], 'CodeDocument': {'tag': 'CodeDocument', 'attrib': []}, 'Name': {'tag': 'Name', 'attrib': []}, 'Series': {'tag': 'Series', 'attrib': []}, 'Number': {'tag': 'Number', 'attrib': []}, 'Date': {'tag': 'Date', 'attrib': []}, 'IssueOrgan': {'tag': 'IssueOrgan', 'attrib': []}, 'Desc': {'tag': 'Desc', 'attrib': []}}}}}, 'FlatsCadastralNumbers': {'tag': 'FlatsCadastralNumbers', 'attrib': [], 'CadastralNumber': {'tag': 'CadastralNumber', 'attrib': []}}, 'CarParkingSpacesCadastralNumbers': {'tag': 'CarParkingSpacesCadastralNumbers', 'attrib': [], 'CadastralNumber': {'tag': 'CadastralNumber', 'attrib': []}}, 'UnitedCadastralNumber': {'tag': 'UnitedCadastralNumber', 'attrib': [], 'CadastralNumber': {'tag': 'CadastralNumber', 'attrib': []}, 'Purpose': {'tag': 'Purpose', 'attrib': []}, 'Name': {'tag': 'Name', 'attrib': []}}, 'FacilityCadastralNumber': {'tag': 'FacilityCadastralNumber', 'attrib': [], 'CadastralNumber': {'tag': 'CadastralNumber', 'attrib': []}, 'Purpose': {'tag': 'Purpose', 'attrib': []}, 'Name': {'tag': 'Name', 'attrib': []}}, 'CulturalHeritage': {'tag': 'CulturalHeritage', 'attrib': [], 'InclusionEGROKN': {'tag': 'InclusionEGROKN', 'attrib': [], 'RegNum': {'tag': 'RegNum', 'attrib': []}, 'ObjCultural': {'tag': 'ObjCultural', 'attrib': []}, 'NameCultural': {'tag': 'NameCultural', 'attrib': []}}, 'AssignmentEGROKN': {'tag': 'AssignmentEGROKN', 'attrib': [], 'RegNum': {'tag': 'RegNum', 'attrib': []}, 'ObjCultural': {'tag': 'ObjCultural', 'attrib': []}, 'NameCultural': {'tag': 'NameCultural', 'attrib': []}}, 'RequirementsEnsure': {'tag': 'RequirementsEnsure', 'attrib': []}, 'Document': {'tag': 'Document', 'attrib': [], 'CodeDocument': {'tag': 'CodeDocument', 'attrib': []}, 'Name': {'tag': 'Name', 'attrib': []}, 'Series': {'tag': 'Series', 'attrib': []}, 'Number': {'tag': 'Number', 'attrib': []}, 'Date': {'tag': 'Date', 'attrib': []}, 'IssueOrgan': {'tag': 'IssueOrgan', 'attrib': []}, 'Desc': {'tag': 'Desc', 'attrib': []}}}}

def print_dict_recursive(d):
list = []
for i in d.items():
    if isinstance(i[1], dict):
        # print(i[1]['tag'], i[1]['attrib'])
        list.append(i[1]['tag'])

return list

list = print_dict_recursive(some_dict)
for i in list:
    print({i: print_dict_recursive(some_dict[i])})

我有一个带有嵌套结构的字典,我试图迭代整个结构并迭代所有 {key: value} 对。上面的代码仅影响两层嵌套并产生以下输出:

{'CadastralBlock': []}
{'ParentCadastralNumbers': ['CadastralNumber']}
{'PrevCadastralNumbers': ['CadastralNumber']}
{'PreviouslyPosted': []}
{'Name': []}
{'ObjectType': []}
{'AssignationBuilding': []}
{'ElementsConstruct': ['Material']}
{'ExploitationChar': []}
{'Floors': []}
{'Area': []}
{'Location': ['FIAS', 'OKATO', 'KLADR', 'OKTMO', 'PostalCode', 'RussianFederation', 'Region', 'District', 'City', 'UrbanDistrict', 'SovietVillage', 'Locality', 'Street', 'Level1', 'Level2', 'Level3', 'Apartment', 'Other', 'Note', 'ReadableAddress']}
{'ObjectPermittedUses': ['ObjectPermittedUse']}
{'CadastralCost': ['DateValuation', 'DateEntering', 'DateApproval', 'ApplicationDate', 'RevisalStatementDate', 'ApplicationLastDate', 'ApprovalDocument']}
{'SubBuildings': ['SubBuilding']}
{'FlatsCadastralNumbers': ['CadastralNumber']}
{'CarParkingSpacesCadastralNumbers': ['CadastralNumber']}
{'UnitedCadastralNumber': ['CadastralNumber', 'Purpose', 'Name']}
{'FacilityCadastralNumber': ['CadastralNumber', 'Purpose', 'Name']}
{'CulturalHeritage': ['InclusionEGROKN', 'AssignmentEGROKN', 'RequirementsEnsure', 'Document']}

Process finished with exit code 0

同时,有些嵌套键没有按照上面的例子显示(例如,'ApprovalDocument'键等)。现阶段我已经进入了死胡同,请专家帮忙。

python
  • 1 个回答
  • 36 Views
Martin Hope
Филипп Шувалов
Asked: 2024-04-04 17:45:51 +0000 UTC

将 json 写入 Excel Pandas 库

  • 5

有一个函数可以将 JSON 数据写入 Excel 文件:

import json
import pandas as pd


def Json_to_Excel(json_data):
    pd.read_json(json_data, convert_axes=True).to_excel('file_name.xlsx', index=False)


json_data = [{'DateForm': '2024-01-12'},
             {'GUID': '15f24792-3013-410b-97bd-cea4d08cf9c5'},
             {'ListType': '4'},
             {'Region': 'Такого тега нет в файле'},
             {'ObjectsType': '002001002000'},
             {'Categories': 'Такого тега нет в файле'}]

Json_to_Excel(json.dumps(json_data))

Json_to_Excel() 函数的输出有些出乎意料:

D:\Python\OKS16\OKS_16\OKS_16.py:149: FutureWarning: Passing literal json to 'read_json' is deprecated and will be removed in a future version. To read from a literal string, wrap it in a 'StringIO' object.
  print(pd.read_json(json_data, convert_axes=True))
0  2024-01-12  ...                      NaN
1         NaN  ...                      NaN
2         NaN  ...                      NaN
3         NaN  ...                      NaN
4         NaN  ...                      NaN
5         NaN  ...  Такого тега нет в файле

[6 rows x 6 columns]

Process finished with exit code 0

如何更正代码,使数据写入一行而不出现 NaN

python
  • 1 个回答
  • 19 Views

Sidebar

Stats

  • 问题 10021
  • Answers 30001
  • 最佳答案 8000
  • 用户 6900
  • 常问
  • 回答
  • Marko Smith

    我看不懂措辞

    • 1 个回答
  • Marko Smith

    请求的模块“del”不提供名为“default”的导出

    • 3 个回答
  • Marko Smith

    "!+tab" 在 HTML 的 vs 代码中不起作用

    • 5 个回答
  • Marko Smith

    我正在尝试解决“猜词”的问题。Python

    • 2 个回答
  • Marko Smith

    可以使用哪些命令将当前指针移动到指定的提交而不更改工作目录中的文件?

    • 1 个回答
  • Marko Smith

    Python解析野莓

    • 1 个回答
  • Marko Smith

    问题:“警告:检查最新版本的 pip 时出错。”

    • 2 个回答
  • Marko Smith

    帮助编写一个用值填充变量的循环。解决这个问题

    • 2 个回答
  • Marko Smith

    尽管依赖数组为空,但在渲染上调用了 2 次 useEffect

    • 2 个回答
  • Marko Smith

    数据不通过 Telegram.WebApp.sendData 发送

    • 1 个回答
  • Martin Hope
    Alexandr_TT 2020年新年大赛! 2020-12-20 18:20:21 +0000 UTC
  • Martin Hope
    Alexandr_TT 圣诞树动画 2020-12-23 00:38:08 +0000 UTC
  • Martin Hope
    Air 究竟是什么标识了网站访问者? 2020-11-03 15:49:20 +0000 UTC
  • Martin Hope
    Qwertiy 号码显示 9223372036854775807 2020-07-11 18:16:49 +0000 UTC
  • Martin Hope
    user216109 如何为黑客设下陷阱,或充分击退攻击? 2020-05-10 02:22:52 +0000 UTC
  • Martin Hope
    Qwertiy 并变成3个无穷大 2020-11-06 07:15:57 +0000 UTC
  • Martin Hope
    koks_rs 什么是样板代码? 2020-10-27 15:43:19 +0000 UTC
  • Martin Hope
    Sirop4ik 向 git 提交发布的正确方法是什么? 2020-10-05 00:02:00 +0000 UTC
  • Martin Hope
    faoxis 为什么在这么多示例中函数都称为 foo? 2020-08-15 04:42:49 +0000 UTC
  • Martin Hope
    Pavel Mayorov 如何从事件或回调函数中返回值?或者至少等他们完成。 2020-08-11 16:49:28 +0000 UTC

热门标签

javascript python java php c# c++ html android jquery mysql

Explore

  • 主页
  • 问题
    • 热门问题
    • 最新问题
  • 标签
  • 帮助

Footer

RError.com

关于我们

  • 关于我们
  • 联系我们

Legal Stuff

  • Privacy Policy

帮助

© 2023 RError.com All Rights Reserve   沪ICP备12040472号-5