Automatic Data Transformation Using Large Language Model: An Experimental Study on Building Energy Data

Existing approaches to automatic data transformation are insufficient to meet the requirements in many real-world scenarios, such as the building sector. First, there is no convenient interface for domain experts to provide domain knowledge easily. Second, they require significant training data collection overheads. Third, the accuracy suffers from complicated schema changes. To bridge this gap, we present a novel approach that leverages the unique capabilities of large language models (LLMs) in coding, complex reasoning, and zero-shot learning to generate SQL code that transforms the source datasets into the target datasets. We demonstrate the viability of this approach by designing an LLM-based framework, termed SQLMorpher, which comprises a prompt generator that integrates the initial prompt with optional domain knowledge and historical patterns in external databases. It also implements an iterative prompt optimization mechanism that automatically improves the prompt based on flaw detection. The key contributions of this work include (1) pioneering an end-to-end LLM-based solution for data transformation, (2) developing a benchmark dataset of 105 real-world building energy data transformation problems, and (3) conducting an extensive empirical evaluation where our approach achieved 96% accuracy in all 105 problems. SQLMorpher demonstrates the effectiveness of utilizing LLMs in complex, domain-specific challenges, highlighting the potential of their potential to drive sustainable solutions.Comment: 10 pages, 7 figure

Price discovery of credit spreads in tranquil and crisis periods

In this paper we investigate the price discovery process in single-name credit spreads obtained from bond, credit default swap (CDS), equity and equity option prices. We analyse short term price discovery by modelling daily changes in credit spreads in the four markets with a vector autoregressive model (VAR). We also look at price discovery in the long run with a vector error correction model (VECM). We find that in the short term the option market clearly leads the other markets in the sub-prime crisis (2007-2009). During the less severe sovereign debt crisis (2009-2012) and the pre-crisis period, options are still important but CDSs become more prominent. In the long run, deviations from the equilibrium relationship with the option market still lead to adjustments in the credit spreads observed or implied from other markets. However, options no longer dominate price discovery in any of the periods considered. Our findings have implications for traders, credit risk managers and financial regulators

Thermoelectric properties of lead chalcogenide core-shell nanostructures

We present the full thermoelectric characterization of nanostructured bulk PbTe and PbTe-PbSe samples fabricated from colloidal core-shell nanoparticles followed by spark plasma sintering. An unusually large thermopower is found in both materials, and the possibility of energy filtering as opposed to grain boundary scattering as an explanation is discussed. A decreased Debye temperature and an increased molar specific heat are in accordance with recent predictions for nanostructured materials. On the basis of these results we propose suitable core-shell material combinations for future thermoelectric materials of large electric conductivities in combination with an increased thermopower by energy filtering.Comment: 12 pages, 8 figure

T cell-inflamed gene expression profile and PD-L1 expression and pembrolizumab efficacy in advanced esophageal cancer

Aim: Investigate the relationship between response to pembrolizumab and expression of the 18-gene T cell-inflamed gene expression profile (TcellinfGEP) or PD-L1 combined positive score (CPS) in esophageal cancer. Materials & methods: This analysis included heavily pretreated patients with advanced/metastatic esophageal/gastroesophageal junction adenocarcinoma or squamous cell carcinoma who received pembrolizumab in the single-arm, phase II study KEYNOTE-180. PD-L1 CPS was evaluated with PD-L1 IHC 22C3 pharmDx. Results: In patients with squamous cell carcinoma, trends toward enrichment for responders were observed for patients with PD-L1 CPS ≥10 tumors. In patients with adenocarcinoma, a trend was observed for TcellinfGEP but not for PD-L1. Conclusion: TcellinfGEP and PD-L1 CPS may enrich for responders to pembrolizumab in patients with esophageal cancer. Clinical Trial Registration: NCT02559687 (ClinicalTrials.gov

Loss of ACS7 confers abiotic stress tolerance by modulating ABA sensitivity and accumulation in Arabidopsis

The phytohormones ethylene and abscisic acid (ABA) play essential roles in the abiotic stress adaptation of plants, with both cross-talk of ethylene signalling and ABA biosynthesis and signalling reported. Any reciprocal effects on each other's biosynthesis, however, remain elusive. ACC synthase (ACS) acts as the key enzyme in ethylene biosynthesis. A pilot study on changes in ACS promoter activities in response to abiotic stresses revealed the unique involvement in abiotic stress responses of the only type 3 ACC synthase, ACS7, among all nine ACSs of Arabidopsis. Hence an acs7 mutant was characterized and its abiotic stress responses were analysed. The acs7 mutant germinated slightly faster than the wild type and subsequently maintained a higher growth rate at the vegetative growth stage. Ethylene emission of acs7 was merely one-third of that of the wild type. acs7 exhibited enhanced tolerance to salt, osmotic, and heat stresses. Furthermore, acs7 seeds were hypersensitive to both ABA and glucose during germination. Transcript analyses revealed that acs7 had elevated transcript levels of the stress-responsive genes involved in the ABA-dependent pathway under salt stress. The ABA level was also higher in acs7 following salt treatment. Our data suggest that ACS7 acts as a negative regulator of ABA sensitivity and accumulation under stress and appears as a node in the cross-talk between ethylene and ABA

Recovering default risk from CDS spreads with a nonlinear filter

We propose a nonlinear filter to estimate the time-varying default risk from the term structure of credit default swap (CDS) spreads. Based on the numerical solution of the Fokker–Planck equation (FPE) using a meshfree interpolation method, the filter performs a joint estimation of the risk-neutral default intensity and CIR model parameters. As the FPE can account for nonlinear functions and non-Gaussian errors, the proposed framework provides outstanding flexibility and accuracy. We test the nonlinear filter on simulated spreads and apply it to daily CDS data of the Dow Jones Industrial Average component companies from 2005 to 2010 with supportive results

Study of J/ψ→ppˉJ/\psi\to p\bar{p} and J/ψ→nnˉJ/\psi\to n\bar{n}

The decays $J/\psi\to p\bar{p}$ and $J/\psi\to n\bar{n}$ have been investigated with a sample of 225.2 million $J/\psi$ events collected with the BESIII detector at the BEPCII $e^+e^-$ collider. The branching fractions are determined to be $\mathcal{B}(J/\psi\to p\bar{p})=(2.112\pm0.004\pm0.031)\times10^{-3}$ and $\mathcal{B}(J/\psi\to n\bar{n})=(2.07\pm0.01\pm0.17)\times10^{-3}$. Distributions of the angle $\theta$ between the proton or anti-neutron and the beam direction are well described by the form $1+\alpha\cos^2\theta$, and we find $\alpha=0.595\pm0.012\pm0.015$ for $J/\psi\to p\bar{p}$ and $\alpha=0.50\pm0.04\pm0.21$ for $J/\psi\to n\bar{n}$. Our branching-fraction results suggest a large phase angle between the strong and electromagnetic amplitudes describing the $J/\psi\to N\bar{N}$ decay.Comment: 16 pages, 13 figures, the 2nd version, submitted to PR

Results from the first use of low radioactivity argon in a dark matter search

Liquid argon is a bright scintillator with potent particle identification properties, making it an attractive target for direct-detection dark matter searches. The DarkSide-50 dark matter search here reports the first WIMP search results obtained using a target of low-radioactivity argon. DarkSide-50 is a dark matter detector, using two-phase liquid argon time projection chamber, located at the Laboratori Nazionali del Gran Sasso. The underground argon is shown to contain Ar-39 at a level reduced by a factor (1.4 +- 0.2) x 10^3 relative to atmospheric argon. We report a background-free null result from (2616 +- 43) kg d of data, accumulated over 70.9 live-days. When combined with our previous search using an atmospheric argon, the 90 % C.L. upper limit on the WIMP-nucleon spin-independent cross section based on zero events found in the WIMP search regions, is 2.0 x 10^-44 cm^2 (8.6 x 10^-44 cm^2, 8.0 x 10^-43 cm^2) for a WIMP mass of 100 GeV/c^2 (1 TeV/c^2 , 10 TeV/c^2).Comment: Accepted by Phys. Rev.

Challenges in QCD matter physics - The Compressed Baryonic Matter experiment at FAIR

Substantial experimental and theoretical efforts worldwide are devoted to explore the phase diagram of strongly interacting matter. At LHC and top RHIC energies, QCD matter is studied at very high temperatures and nearly vanishing net-baryon densities. There is evidence that a Quark-Gluon-Plasma (QGP) was created at experiments at RHIC and LHC. The transition from the QGP back to the hadron gas is found to be a smooth cross over. For larger net-baryon densities and lower temperatures, it is expected that the QCD phase diagram exhibits a rich structure, such as a first-order phase transition between hadronic and partonic matter which terminates in a critical point, or exotic phases like quarkyonic matter. The discovery of these landmarks would be a breakthrough in our understanding of the strong interaction and is therefore in the focus of various high-energy heavy-ion research programs. The Compressed Baryonic Matter (CBM) experiment at FAIR will play a unique role in the exploration of the QCD phase diagram in the region of high net-baryon densities, because it is designed to run at unprecedented interaction rates. High-rate operation is the key prerequisite for high-precision measurements of multi-differential observables and of rare diagnostic probes which are sensitive to the dense phase of the nuclear fireball. The goal of the CBM experiment at SIS100 (sqrt(s_NN) = 2.7 - 4.9 GeV) is to discover fundamental properties of QCD matter: the phase structure at large baryon-chemical potentials (mu_B > 500 MeV), effects of chiral symmetry, and the equation-of-state at high density as it is expected to occur in the core of neutron stars. In this article, we review the motivation for and the physics programme of CBM, including activities before the start of data taking in 2022, in the context of the worldwide efforts to explore high-density QCD matter.Comment: 15 pages, 11 figures. Published in European Physical Journal