Enhancing Data Analysis and Automation: Integrating Python with Microsoft Excel for Non-Programmers

Microsoft Excel is essential for the End-User Approach (EUA), offering versatility in data organization, analysis, and visualization, as well as widespread accessibility. It fosters collaboration and informed decision-making across diverse domains. Conversely, Python is indispensable for professional programming due to its versatility, readability, extensive libraries, and robust community support. It enables efficient development, advanced data analysis, data mining, and automation, catering to diverse industries and applications. However, one primary issue when using Microsoft Excel with Python libraries is compatibility and interoperability. While Excel is a widely used tool for data storage and analysis, it may not seamlessly integrate with Python libraries, leading to challenges in reading and writing data, especially in complex or large datasets. Additionally, manipulating Excel files with Python may not always preserve formatting or formulas accurately, potentially affecting data integrity. Moreover, dependency on Excel’s graphical user interface (GUI) for automation can limit scalability and reproducibility compared to Python’s scripting capabilities. This paper covers the integration solution of empowering non-programmers to leverage Python’s capabilities within the familiar Excel environment. This enables users to perform advanced data analysis and automation tasks without requiring extensive programming knowledge. Based on Soliciting feedback from non-programmers who have tested the integration solution, the case study shows how the solution evaluates the ease of implementation, performance, and compatibility of Python with Excel versions.

Performance Analysis and Optimization of Energy Harvesting Modulation for Multi-User Integrated Data and Energy Transfer

Integrated data and energy transfer(IDET)enables the electromagnetic waves to transmit wireless energy at the same time of data delivery for lowpower devices.In this paper,an energy harvesting modulation(EHM)assisted multi-user IDET system is studied,where all the received signals at the users are exploited for energy harvesting without the degradation of wireless data transfer(WDT)performance.The joint IDET performance is then analysed theoretically by conceiving a practical time-dependent wireless channel.With the aid of the AO based algorithm,the average effective data rate among users are maximized by ensuring the BER and the wireless energy transfer(WET)performance.Simulation results validate and evaluate the IDET performance of the EHM assisted system,which also demonstrates that the optimal number of user clusters and IDET time slots should be allocated,in order to improve the WET and WDT performance.

Integrating Virtual Reality and Energy Analysis with BIM to Optimize Window-to-Wall Ratio and Building’s Orientation for Age-in-Place Design at the Conceptual Stage

This study unfolds an innovative approach aiming to address the critical role of building design in global energy consumption, focusing on optimizing the Window-to-Wall Ratio (WWR), since buildings account for approximately 30% of total energy consumed worldwide. The greatest contributors to energy expenditure in buildings are internal artificial lighting and heating and cooling systems. The WWR, determined by the proportion of the building’s glazed area to its wall area, is a significant factor influencing energy efficiency and minimizing energy load. This study introduces the development of a semi-automated computer model designed to offer a real-time, interactive simulation environment, fostering improving communication and engagement between designers and owners. The said model serves to optimize both the WWR and building orientation to align with occupants’ needs and expectations, subsequently reducing annual energy consumption and enhancing the overall building energy performance. The integrated model incorporates Building Information Modeling (BIM), Virtual Reality (VR), and Energy Analysis tools deployed at the conceptual design stage, allowing for the amalgamation of owners’ inputs in the design process and facilitating the creation of more realistic and effective design strategies.

Analysis of Traffic Accidents Based on the Integration Model

To enhance the safety of road traffic operations,this paper proposed a model based on stacking integrated learning utilizing American road traffic accident statistics.Initially,the process involved data cleaning,transformation,and normalization.Subsequently,various classification models were constructed,including logistic regression,k-nearest neighbors,gradient boosting,decision trees,AdaBoost,and extra trees models.Evaluation metrics such as accuracy,precision,recall,F1 score,and Hamming loss were employed.Upon analysis,the passive-aggressive classifier model exhibited superior comprehensive indices compared to other models.Based on the model’s output results,an in-depth examination of the factors influencing traffic accidents was conducted.Additionally,measures and suggestions aimed at reducing the incidence of severe traffic accidents were presented.These findings served as a valuable reference for mitigating the occurrence of traffic accidents.

Application of Choquet Integral-Importance-Performance Analysis and TOPSIS Methods in Approaching the Preference Factors of Calligraphy and Seal Engraving Imagery

Classical Chinese characters,presented through calligraphy,seal engraving,or painting,can exhibit different aesthetics and essences of Chinese characters,making them the most important asset of the Chinese people.Calligraphy and seal engraving,as two closely related systems in traditional Chinese art,have developed through the ages.Due to changes in lifestyle and advancements in modern technology,their original functions of daily writing and verification have gradually diminished.Instead,they have increasingly played a significant role in commercial art.This study utilizes the Evaluation Grid Method(EGM)and the Analytic Hierarchy Process(AHP)to research the key preference factors in the application of calligraphy and seal engraving imagery.Different from the traditional 5-point equal interval semantic questionnaire,this study employs a non-equal interval semantic questionnaire with a golden ratio scale,distinguishing the importance ratio of adjacent semantic meanings and highlighting the weighted emphasis on visual aesthetics.Additionally,the study uses Importance-Performance Analysis(IPA)and Technique for Order Preference by Similarity to Ideal Solution(TOPSIS)to obtain the key preference sequence of calligraphy and seal engraving culture.Plus,the Choquet integral comprehensive evaluation is used as a reference for IPA comparison.It is hoped that this study can provide cultural imagery references and research methods,injecting further creativity into industrial design.

An Empirical Application of User-Guided Program Analysis

Although static program analysis methods are frequently employed to enhance software quality,their efficiency in commercial settings is limited by their high false positive rate.The EUGENE tool can effectively lower the false positive rate.However,in continuous integration(CI)environments,the code is always changing,and user feedback from one version of the software cannot be applied to a subsequent version.Additionally,people find it difficult to distinguish between true positives and false positives in the analytical output.In this study,we developed the EUGENE-CI technique to address the CI problem and the EUGENE-rank lightweight heuristic algorithm to rate the reports of the analysis output in accordance with the likelihood that they are true positives.On the three projects ethereum,go-cloud,and kubernetes,we assessed our methodologies.According to the trial findings,EUGENE-CI may drastically reduce false positives while EUGENE-rank can make it much easier for users to identify the real positives among a vast number of reports.We paired our techniques with GoInsight~1 and discovered a vulnerability.We also offered a patch to the community.

CAUCHY TYPE INTEGRALS AND A BOUNDARY VALUE PROBLEM IN A COMPLEX CLIFFORD ANALYSIS

Clifford analysis is an important branch of modern analysis;it has a very important theoretical significance and application value,and its conclusions can be applied to the Maxwell equation,Yang-Mill field theory,quantum mechanics and value problems.In this paper,we first give the definition of a quasi-Cauchy type integral in complex Clifford analysis,and get the Plemelj formula for it.Second,we discuss the H?lder continuity for the Cauchy-type integral operators with values in a complex Clifford algebra.Finally,we prove the existence of solutions for a class of linear boundary value problems and give the integral representation for the solution.

Time series analysis-based seasonal autoregressive fractionally integrated moving average to estimate hepatitis B and C epidemics in China

BACKGROUND Hepatitis B(HB)and hepatitis C(HC)place the largest burden in China,and a goal of eliminating them as a major public health threat by 2030 has been set.Making more informed and accurate forecasts of their spread is essential for developing effective strategies,heightening the requirement for early warning to deal with such a major public health threat.AIM To monitor HB and HC epidemics by the design of a paradigmatic seasonal autoregressive fractionally integrated moving average(SARFIMA)for projections into 2030,and to compare the effectiveness with the seasonal autoregressive integrated moving average(SARIMA).METHODS Monthly HB and HC incidence cases in China were obtained from January 2004 to June 2023.Descriptive analysis and the Hodrick-Prescott method were employed to identify trends and seasonality.Two periods(from January 2004 to June 2022 and from January 2004 to December 2015,respectively)were used as the training sets to develop both models,while the remaining periods served as the test sets to evaluate the forecasting accuracy.RESULTS There were incidents of 23400874 HB cases and 3590867 HC cases from January 2004 to June 2023.Overall,HB remained steady[average annual percentage change(AAPC)=0.44,95%confidence interval(95%CI):-0.94-1.84]while HC was increasing(AAPC=8.91,95%CI:6.98-10.88),and both had a peak in March and a trough in February.In the 12-step-ahead HB forecast,the mean absolute deviation(15211.94),root mean square error(18762.94),mean absolute percentage error(0.17),mean error rate(0.15),and root mean square percentage error(0.25)under the best SARFIMA(3,0,0)(0,0.449,2)12 were smaller than those under the best SARIMA(3,0,0)(0,1,2)12(16867.71,20775.12,0.19,0.17,and 0.27,respectively).Similar results were also observed for the 90-step-ahead HB,12-step-ahead HC,and 90-step-ahead HC forecasts.The predicted HB incidents totaled 9865400(95%CI:7508093-12222709)cases and HC totaled 1659485(95%CI:856681-2462290)cases during 2023-2030.CONCLUSION Under current interventions,China faces enormous challenges to eliminate HB and HC epidemics by 2030,and effective strategies must be reinforced.The integration of SARFIMA into public health for the management of HB and HC epidemics can potentially result in more informed and efficient interventions,surpassing the capabilities of SARIMA.

Approach to conceptual data integration for multidimensional data analysis in e-commerce

In e-commerce the multidimensional data analysis based on the Web data needs integrating various data sources such as XML data and relational data on the conceptual level. A conceptual data description approach to multidimensional data model the UML galaxy diagram is presented in order to conduct multidimensional data analysis for multiple subjects. The approach is illuminated using a case of 2_roots UML galaxy diagram that takes marketing analysis of TV products involved one retailer and several suppliers into consideration.

Co-integration Analysis on the Relationship between Methane Energy Development and Economic Growth in the City of Huixian

Based on the statistical data of Huixian from 1992 to 2010, we analyze the long-term and short-term relationship between Huixian's methane energy development and GDP by using co-integration test and error correction model. The empirical results show that there is a long-term equilibrium relationship between methane energy and GDP in the city of Huixian, and which is the one-way Granger causality of methane and GDP. In conclusion, the paper puts forward some steps about spurring economic growth, methane development and utilization in Huixian.

Co-integration Analysis of the Relationship between Residents' Consumer Spending and GDP in Hubei Province

In accordance with the economic data from Statistical Communique on National Economy and Social Development in Hubei Province in the period 1980-2009, we use co-integration analysis method to research the impact of GDP growth on residents' consumer spending. Result shows that although there are differences between GDP and residents' consumer spending in the short term, the equilibrium relationship exists between them, namely, the co-integration relationship, showing consistency in trends.

Research on the Comparison and Integration of Chinese and Western Music Cultures

This research undertakes a nuanced examination of the intersections and distinctions between these two diverse musical traditions.Employing a meticulous comparative analysis,the study scrutinizes fundamental musical elements such as scales,modes,and compositional styles,illuminating shared threads and distinctive attributes that characterize Chinese and Western music.Against the backdrop of contemporary global dynamics,the research investigates the ongoing integration of these musical cultures.It explores the impact of globalization and technological advancements,revealing instances of cross-cultural collaboration and the emergence of hybrid musical forms.Augmenting theoretical discussions with concrete case studies,the paper offers illuminating examples of how Chinese and Western musical elements interweave,contributing to the evolving landscape of global music.This research not only advances scholarly understanding but also contributes practical insights for musicians,educators,and enthusiasts navigating the evolving dynamics of cross-cultural musical expression.By elucidating the intricate relationship between Chinese and Western music cultures,the paper underscores the richness borne out of their interaction and the cultural synthesis that defines contemporary musical landscapes.

Obstacles to the Integrated Care of Children Aged 6 to 59 Months Suffering from Acute and Severe Malnutrition at the Chu-Me and HATC of N’Djamena/Chad

Introduction: the problem of Severe Acute Malnutrition (SAM) and its consequences concern and challenge all social actors worldwide. The objective of the study was to identify the real obstacles that actors face in the integrated management of children aged 6 - 59 months suffering from SAM at the University Hospital of Mother and Child (CHUME) and the Chad-China Friendship Hospital (HATC) of N’Djamena. Methodology: this is a cross-sectional descriptive and interpretative study conducted from January to October 2023 at the CHUME and HATC of N’Djamena. It is based on questionnaires and direct observation of two hundred and thirty-six (236) parents or guardians of malnourished children admitted to these health facilities. All 236 agreed to participate freely in this study. Results: it appears from this study that the obstacles to the integrated management of malnourished children were: poor care-care relationship (26.7%) permanent product breaks (22.9%), the direct costs of services ranged from 30,000 to 60,000 FCFA (41.53%), drugs used for the treatment of patients came from the street (66.10%), malaria and anemia occupy an important place (27.5%), 57.2% respondents had monthly income below 60,000 CFAF. Conclusion: the present study carried out has identified the real bottlenecks to the integrated management of children suffering from SAM in the therapeutic nutritional units of the city of N’Djamena. .

Feasibility Analysis of IMA Configuration Design Tool

With the widespread application of integrated modular aviation(IMA)electronic systems,the requirements of IMA characteristic analysis and configuration generation have also improved significantly."Configuration and design system based on AADL models(real-time,reliability,interactive complexity,and schedulability)analysis of the AADL model"mainly get through key characteristic analysis for optimization,combined with input of component parameter information and constraint information,assist designers in generating system configuration information,and form a comprehensive modular avionics system resource configuration strategy generation platform.Also,the tool can generate configuration plans for avionics system software and hardware physical architecture configuration.The analysis of the avionics system model mainly involves designers inputting the existing system model architecture for multi characteristic analysis,it can realize the multi-character analysis based on software intensive system architecture models for software dense systems.Inter-complexity and schedulability analysis,and according to characteristic constraint analysis、system model assessment parameters and system architecture constraint parameters to generate configuration scheme information that meets the requirements.The system can meet domestic and foreign software-intensive systems and meet its quality requirements.

Integrity and Failure Analysis of Cement Sheath Subjected to Coalbed Methane Fracturing

Perforation and fracturing are typically associated with the development of coalbed methane wells.As the cement sheath is prone to failure during this process,in this work,the effects of the casing pressure,elastic modulus of the cement,elastic modulus of the formation,and casing eccentricity on the resulting stresses are analyzed in the frame of a finite element method.Subsequently,sensitivity response curves of the cement sheath stress are plotted by normalizing all factors.The results show that the maximum circumferential stress and Mises stress of the cement sheath increase with the casing internal pressure,elastic modulus of the cement and casing eccentricity.As the elastic modulus of the formation increases,the maximum circumferential stress of the cement sheath decreases,and its maximum Mises stress increases slightly.The cement sheath undergoes tensile failure during coalbed methane fracturing.The stress sensitivity of the cement sheath to the influential parameters is in the following order:casing internal pressure>elastic modulus of cement sheath>casing eccentricity>elastic modulus of formation.

Integrated classification method of tight sandstone reservoir based on principal component analysise simulated annealing genetic algorithmefuzzy cluster means

In this research,an integrated classification method based on principal component analysis-simulated annealing genetic algorithm-fuzzy cluster means(PCA-SAGA-FCM)was proposed for the unsupervised classification of tight sandstone reservoirs which lack the prior information and core experiments.A variety of evaluation parameters were selected,including lithology characteristic parameters,poro-permeability quality characteristic parameters,engineering quality characteristic parameters,and pore structure characteristic parameters.The PCA was used to reduce the dimension of the evaluation pa-rameters,and the low-dimensional data was used as input.The unsupervised reservoir classification of tight sandstone reservoir was carried out by the SAGA-FCM,the characteristics of reservoir at different categories were analyzed and compared with the lithological profiles.The analysis results of numerical simulation and actual logging data show that:1)compared with FCM algorithm,SAGA-FCM has stronger stability and higher accuracy;2)the proposed method can cluster the reservoir flexibly and effectively according to the degree of membership;3)the results of reservoir integrated classification match well with the lithologic profle,which demonstrates the reliability of the classification method.

UAV-mounted Ground Penetrating Radar: an example for the stability analysis of a mountain rock debris slope

This paper describes scientific research conducted to highlight the potential of an integrated GPR-UAV system in engineering-geological applications.The analysis focused on the stability of a natural scree slope in the Germanasca Valley,in the western Italian Alps.As a consequence of its steep shape and the related geological hazard,the study used different remote sensed methodologies such as UAV photogrammetry and geophysics survey by a GPR-drone integrated system.Furthermore,conventional in-situ surveys led to the collection of geological and geomorphological data.The use of the UAV-mounted GPR allowed us to investigate the bedrock depth under the detrital slope deposit,using a non-invasive technique able to conduct surveys on inaccessible areas prone to hazardous conditions for operators.The collected evidence and the results of the analysis highlighted the stability of the slope with Factors of Safety,verified in static conditions(i.e.,natural static condition and static condition with snow cover),slightly above the stability limit value of 1.On the contrary,the dynamic loading conditions(i.e.,seismic action applied)showed a Factor of Safety below the stability limit value.The UAV-mounted GPR represented an essential contribution to the surveys allowing the definition of the interface debris deposit-bedrock,which are useful to design the slope model and to evaluate the scree slope stability in different conditions.

Integrated analysis of comorbidity, pregnant outcomes, and amniotic fluid cytogenetics of fetuses with persistent left superior vena cava

BACKGROUND Persistent left superior vena cava(PLSVC)is the most common venous system variant.The clinical characteristics and amniotic fluid cytogenetics of fetuses with PLSVC remain to be further explored.AIM To develop reliable prenatal diagnostic recommendations through integrated analysis of the clinical characteristics of fetuses with PLSVC.METHODS Cases of PLSVC diagnosed using prenatal ultrasonography between September 2019 and November 2022 were retrospectively studied.The clinical characteristics of the pregnant women,ultrasonic imaging information,gestational age at diagnosis,pregnancy outcomes,and amniocentesis results were summarized and analyzed using categorical statistics and the chi-square test or Fisher’s exact test.RESULTS Of the 97 cases diagnosed by prenatal ultrasound,49(50.5%)had isolated PLSVC and 48(49.5%)had other structural abnormalities.The differences in pregnancy outcomes and amniocentesis conditions between the two groups were statistically significant(P<0.05).No significant differences were identified between the two groups in terms of advanced maternal age and gestational age(P>0.05).According to the results of the classification statistics,the most common intrac-ardiac abnormality was a ventricular septal defect and the most common extrac-ardiac abnormality was a single umbilical artery.In the subgroup analysis,the concurrent combination of intra-and extracardiac structural abnormalities was a risk factor for adverse pregnancy outcomes(odds ratio>1,P<0.05).Additional-ly,all abnormal cytogenetic findings on amniocentesis were observed in the comorbidity group.One case was diagnosed with 21-trisomy and six cases was diagnosed with chromosome segment duplication.CONCLUSION Examination for other structural abnormalities is strongly recommended when PLSVC is diagnosed.Poorer pregnancy outcomes and increased amniocentesis were observed in PLSVC cases with other structural abnor-malities.Amniotic fluid cytogenetics of fetuses is recommended for PLSVC with other structural abnormalities.

Applications of time series analysis in epidemiology: Literature review and our experience during COVID-19 pandemic

Time series analysis is a valuable tool in epidemiology that complements the classical epidemiological models in two different ways:Prediction and forecast.Prediction is related to explaining past and current data based on various internal and external influences that may or may not have a causative role.Forecasting is an exploration of the possible future values based on the predictive ability of the model and hypothesized future values of the external and/or internal influences.The time series analysis approach has the advantage of being easier to use(in the cases of more straightforward and linear models such as Auto-Regressive Integrated Moving Average).Still,it is limited in forecasting time,unlike the classical models such as Susceptible-Exposed-Infectious-Removed.Its applicability in forecasting comes from its better accuracy for short-term prediction.In its basic form,it does not assume much theoretical knowledge of the mechanisms of spreading and mutating pathogens or the reaction of people and regulatory structures(governments,companies,etc.).Instead,it estimates from the data directly.Its predictive ability allows testing hypotheses for different factors that positively or negatively contribute to the pandemic spread;be it school closures,emerging variants,etc.It can be used in mortality or hospital risk estimation from new cases,seroprevalence studies,assessing properties of emerging variants,and estimating excess mortality and its relationship with a pandemic.

Temperature-Triggered Hardware Trojan Based Algebraic Fault Analysis of SKINNY-64-64 Lightweight Block Cipher

SKINNY-64-64 is a lightweight block cipher with a 64-bit block length and key length,and it is mainly used on the Internet of Things(IoT).Currently,faults can be injected into cryptographic devices by attackers in a variety of ways,but it is still difficult to achieve a precisely located fault attacks at a low cost,whereas a Hardware Trojan(HT)can realize this.Temperature,as a physical quantity incidental to the operation of a cryptographic device,is easily overlooked.In this paper,a temperature-triggered HT(THT)is designed,which,when activated,causes a specific bit of the intermediate state of the SKINNY-64-64 to be flipped.Further,in this paper,a THT-based algebraic fault analysis(THT-AFA)method is proposed.To demonstrate the effectiveness of the method,experiments on algebraic fault analysis(AFA)and THT-AFA have been carried out on SKINNY-64-64.In the THT-AFA for SKINNY-64-64,it is only required to activate the THT 3 times to obtain the master key with a 100%success rate,and the average time for the attack is 64.57 s.However,when performing AFA on this cipher,we provide a relation-ship between the number of different faults and the residual entropy of the key.In comparison,our proposed THT-AFA method has better performance in terms of attack efficiency.To the best of our knowledge,this is the first HT attack on SKINNY-64-64.