Nueva publicación

Encontrar

Pregunta
· 1 jul, 2025

Need to merge 2 pipe delimited files after converting it into json

The below code is not working. its unable retrieve Record count and merge files

Class Util

{

 

ClassMethod zPyRecordCount(inputfile) As %Integer [ Language = python ]

{

    import pandas as pd

    import iris

    import io

 

    try:

        df = pd.read_csv(inputfile, sep='|')

        recordcount=len(df.index)

        sys.stdout.write(len(df.index))

        return recordcount

 

    except Exception as e:

        return 0

}

 

ClassMethod zPymergefiles(file1, file2, outputfilename) As %Boolean [ Language = python ]

{

 

    import pandas as pd

    import iris

    import io

 

    try:

        dataframe1=pd.read_csv(file1, sep='|')

        dataframe2=pd.read_csv(file2, sep='|')

        jsondf1 = dataframe1.to_json(orient='records', indent=0)

        jsondf2 = dataframe2.to_json(orient='records', indent=0)

        mergedjsondf=pd.concat([jsondf1, jsondf2], ignore_index=True)

        with open(outfilename, 'w', encoding='utf-8') as f:

            json.dump(data, f, indent=0, ensure_ascii=False)

        return 1

    except Exception as e:

        return 0

}

 

}

Set mergeStatus=##class(Util).zPymergefiles(inputfile1,inputfile2, "outfile1.json")

1 nuevo comentario
Comentarios (2)3
Inicie sesión o regístrese para continuar
Artículo
· 1 jul, 2025 Lectura de 2 min

Milwaukee Packout Medium Toolbox

Milwaukee Packout Medium Toolbox

The Milwaukee Packout Medium Toolbox is a go-to choice for professionals and DIYers who need a rugged, reliable, and customizable storage solution. Built to withstand the toughest job site conditions, this toolbox combines strength, versatility, and smart design as part of Milwaukee’s modular Packout system.

Durable Construction

Made from impact-resistant polymers, the Medium Toolbox is designed to endure rough handling, extreme temperatures, and harsh environments. The reinforced corners and weather-sealed lid help keep your tools protected from water, dust, and debris, making it suitable for both indoor and outdoor work.

Smart Storage

Inside, the toolbox offers ample space for a variety of tools, with an interior tray that helps organize smaller items like bits, fasteners, or hand tools. The box is deep enough to store power tools and other bulky equipment, making it ideal for a wide range of applications.

Modular Compatibility

One of the standout features of the Milwaukee Packout system is its modularity. The Medium Toolbox easily connects with other Packout components—such as rolling toolboxes, organizers, and totes—thanks to its intuitive locking mechanism. This allows you to build a customized storage stack tailored to your workflow.

Portable and Secure

Despite its solid build, the toolbox remains easy to carry thanks to its heavy-duty handle and compact size. Metal-reinforced locking points add an extra layer of security, allowing you to lock the box when left unattended.

Conclusion

The Milwaukee Packout Medium Toolbox offers a perfect balance between portability and capacity, making it a smart investment for those who value durability, organization, and flexibility on the job. Whether you're a contractor, technician, or hobbyist, this toolbox keeps your gear safe, accessible, and ready to move when you are.

Comentarios (0)1
Inicie sesión o regístrese para continuar
Anuncio
· 1 jul, 2025

Go Deeper with a Live Course

Hi Community,

Looking for a more personal approach to learning InterSystems products?

Try one of our live classroom courses! In just a few days, our experienced instructors will help you get up to speed, no matter your role.

Take a live course: view the schedule  

Upcoming courses:

Comentarios (0)1
Inicie sesión o regístrese para continuar
Resumen
· 1 jul, 2025

Résumé de la communauté des développeurs d'InterSystems, Juin 2025

Bonjour, voici la newsletter de la communauté des développeurs de Juin 2025.
Statistiques générales
✓ Nouvelles publications 24 publiées le Juin :
 10 nouveaux articles
 13 nouvelles annonces
 1 nouvelle question
✓ Nouveaux membres 6 ayant rejoint le Juin
✓ Publications 1,199 publiées depuis le début
✓ Membres 178 ayant rejoint depuis le début
Meilleures publications
Un coup de poids
Par Andre Larsen Barbosa
Les meilleurs auteurs du mois
Articles
#InterSystems IRIS
#HealthShare
#InterSystems IRIS for Health
#Summit
Annonces
#InterSystems IRIS
#Communauté des développeurs officielle
#InterSystems officiel
#Autre
InterSystems sur HIMSS25 Europe
Par Irène Mykhailova
#Supply Chain Orchestrator
#IRIS contest
#HealthShare
Questions
#InterSystems IRIS
Juin, 2025Month at a GlanceInterSystems Developer Community
Comentarios (0)1
Inicie sesión o regístrese para continuar