NL2Formula: Generating Spreadsheet Formulas from Natural Language Queries

Writing formulas on spreadsheets, such as Microsoft Excel and Google Sheets, is a widespread practice among users performing data analysis. However, crafting formulas on spreadsheets remains a tedious and error-prone task for many end-users, particularly when dealing with complex operations. To alleviate the burden associated with writing spreadsheet formulas, this paper introduces a novel benchmark task called NL2Formula, with the aim to generate executable formulas that are grounded on a spreadsheet table, given a Natural Language (NL) query as input. To accomplish this, we construct a comprehensive dataset consisting of 70,799 paired NL queries and corresponding spreadsheet formulas, covering 21,670 tables and 37 types of formula functions. We realize the NL2Formula task by providing a sequence-to-sequence baseline implementation called fCoder. Experimental results validate the effectiveness of fCoder, demonstrating its superior performance compared to the baseline models. Furthermore, we also compare fCoder with an initial GPT-3.5 model (i.e., text-davinci-003). Lastly, through in-depth error analysis, we identify potential challenges in the NL2Formula task and advocate for further investigation.Comment: To appear at EACL 202

Social capital and healthy eating among two ethnic minority groups in Yunnan Province, Southwest China: the mediating role of social support and nutrition knowledge

BackgroundAlthough social capital has been linked to dietary intake particularly in disadvantaged populations, little is known about the mechanisms. This study aimed to investigate whether social support (SS) and nutrition knowledge (NK) mediate the association between social capital and healthy eating habits.MethodsA probability sample of two ethnic minority groups in Yunnan Province, Southwest China were included (n = 1,033, mean age 47.5 ± 14.7 years). Bonding and bridging social capital (BOC and BRC) were assessed with the Personal Social Capital Scale (PSCS-16). Dietary data were evaluated with the Chinese Healthy Eating Index (CHEI), a measure of diet quality which reflects adherence to the Chinese Dietary Guidelines. NK and SS were measured with a validated questionnaire and scale, respectively. Structural Equation Modeling was used to calculate the direct, indirect and total effects of social capital on CHEI scores.ResultsThe mean score of CHEI was 57.4 ± 9.8, which was significantly lower in men and older people. Low adherence to dietary guidelines were to observed in the consumption of dairy, beans, nuts, animal-source food vegetables and fruits. BOC and BRC were positively associated with CHEI score (β = 0.37 and 0.38, all p < 0.05). Social support and nutrition knowledge mediated 45.9 and 39.5% of the total effect of social capital on CHEI score, respectively.ConclusionSocial capital appears to enhance adherence to dietary guidelines by improving nutrition knowledge and social support. Nutrition promotion programs therefore should consider incorporating strategies that foster social capital development, particularly in disadvantaged populations

Fangchinoline Inhibits Human Immunodeficiency Virus Type 1 Replication by Interfering with gp160 Proteolytic Processing

The introduction of highly active antiretroviral therapy has led to a significant reduction in the morbidity and mortality of acquired immunodeficiency syndrome patients. However, the emergence of drug resistance has resulted in the failure of treatments in large numbers of patients and thus necessitates the development of new classes of anti-HIV drugs. In this study, more than 200 plant-derived small-molecule compounds were evaluated in a cell-based HIV-1 antiviral screen, resulting in the identification of a novel HIV-1 inhibitor (fangchinoline). Fangchinoline, a bisbenzylisoquinoline alkaloid isolated from Radix Stephaniae tetrandrae, exhibited antiviral activity against HIV-1 laboratory strains NL4-3, LAI and BaL in MT-4 and PM1 cells with a 50% effective concentration ranging from 0.8 to 1.7 µM. Mechanism-of-action studies showed that fangchinoline did not exhibit measurable antiviral activity in TZM-b1 cells but did inhibit the production of infectious virions in HIV-1 cDNA transfected 293T cells, which suggests that the compound targets a late event in infection cycle. Furthermore, the antiviral effect of fangchinoline seems to be HIV-1 enve1ope-dependent, as the production of infectious HIV-1 particles packaged with a heterologous envelope, the vesicular stomatitis virus G glycoprotein, was unaffected by fangchinoline. Western blot analysis of HIV envelope proteins expressed in transfected 293T cells and in isolated virions showed that fangchinoline inhibited HIV-1 gp160 processing, resulting in reduced envelope glycoprotein incorporation into nascent virions. Collectively, our results demonstrate that fangchinoline inhibits HIV-1 replication by interfering with gp160 proteolytic processing. Fangchinoline may serve as a starting point for developing a new HIV-1 therapeutic approach

Plasma microRNA Profiles as a Potential Biomarker in Differentiating Adult-Onset Still's Disease From Sepsis

Adult-onset Still's disease (AOSD) is a systemic inflammatory disease characterized by cytokine storm. However, a diagnostic test for AOSD in clinical use is yet to be validated. The aim of our study was to identify non-invasive biomarkers with high specificity and sensitivity to diagnosis of AOSD. MicroRNA (miRNA) profiles in PBMC from new-onset AOSD patients without any treatment and healthy controls (HCs) were analyzed by miRNA deep sequencing. Plasma samples from 100 AOSD patients and 60 HCs were used to validated the expression levels of miRNA by qRT-PCR. The correlations between expression levels of miRNAs and clinical manifestations were analyzed using advanced statistical models. We found that plasma samples from AOSD patients showed a distinct miRNA expression profile. Five miRNAs (miR-142-5p, miR-101-3p, miR-29a-3p, miR-29c-3p, and miR-141-3p) were significantly upregulated in plasma of AOSD patients compared with HCs both in training and validation sets. We discovered a panel including 3 miRNAs (miR-142-5p, miR-101-3p, and miR-29a-3p) that can predict the probability of AOSD with an area under the receiver operating characteristic (ROC) curve of 0.8250 in training and validation sets. Moreover, the expression levels of 5 miRNAs were significantly higher in active AOSD patients compared with those in inactive patients. In addition, elevated level of miR-101-3p was found in AOSD patients with fever, sore throat and arthralgia symptoms; the miR-101-3p was also positively correlated with the levels of IL-6 and TNF-α in serum. Furthermore, five miRNAs (miR-142-5p, miR-101-3p, miR-29c-3p, miR-29a-3p, and miR-141-3p) expressed in plasma were significantly higher in AOSD patients than in sepsis patients (P < 0.05). The AUC value of 4-miRNA panel (miR-142-5p, miR-101-3p, miR-29c-3p, and miR-141-3p) for AOSD diagnosis from sepsis was 0.8448, revealing the potentially diagnostic value to distinguish AOSD patients from sepsis patients. Our results have identified a specific plasma miRNA signature that may serve as a potential non-invasive biomarker for diagnosis of AOSD and monitoring disease activity

A Survey and Taxonomy of Cloud Migration

Cloud computing has certainly gained attention and skyrocketed in the technical and economic world because of the appealing features. With decades of development there are lots of on-premises applications and systems in use. Consequently, the demand of migrating on-premises applications and systems to the cloud computing is gigantic. Thus, the cloud migration is not systematically reviewed with a proper taxonomy due to the variety of cloud computing architecture and the complexity of applications and systems. This paper surveys the cloud computing architectures and cloud migration decision frameworks by both the industry and the academia. Then, it proposes cloud migration taxonomy for a clear understanding of related approaches. Finally, it addresses the future challenges and direction as well. ? 2014 IEEE.EI175-1802015-Octobe

Service Composition Pattern Generation for Cloud Migration: A Graph Similarity Analysis Approach

The demands of migrating existing on-premises complex enterprise applications to cloud dramatically increase with the wide adoption of cloud computing. A recent research validates the possibility to combine multiple proprietary migration services offered by different vendors together to complete cloud migration. Pattern based service composition has been proven as an appealing approach to accelerate the service composition and ensure the qualities in the Service Oriented Architecture (SOA) domain and can be applied to the cloud migration service composition theoretically. However, current pattern generation approaches are not applicable for the cloud migration due to lack of either existing cloud migration business process knowledge or execution logs. This paper proposes a novel approach to generate cloud migration patterns from a set of service composition solutions. We formalize the pattern generation as a special graph similarity matching problem and present an algorithm to calculate the similarity of these service composition solutions. Patterns are chosen out of the solutions by similarity with designed criteria. The benchmark results and quantitative analysis show that our proposed approach is effective and efficient in pattern generation for cloud migration. ? 2014 IEEE.EICPCI-S(ISTP)

Dietary Patterns in Relation to General and Central Obesity among Adults in Southwest China

Dietary patterns represent a broader picture of food consumption, and are better correlated with a variety of health outcomes. However, few studies have been conducted to explore the associations between dietary patterns and obesity in Southwest China. Data from the 2010–2012 National Nutrition Survey in the province of Yunnan, Southwest China, were analyzed (n = 1604, aged 18–80 years). Dietary data were collected using the 24 h dietary recall over three consecutive days. Height, weight, and waist circumference were measured following standard methods. Exploratory factor analysis was used to identify dietary patterns. Logistic regression was used to explore the association between dietary patterns and obesity. Three distinct dietary patterns were identified, which were labeled as traditional, modern, and tuber according to their key components. With potential confounders adjusted, adults in the highest quartile of the modern pattern were at higher risk of general and central obesity (odds ratio (OR) 1.95, 95% confidence interval (CI) 1.15–3.48; OR 2.01, 95% CI 1.37–2.93). In contrast, adults in the highest quartile of the tuber pattern were at lower risk of general and central obesity (OR 0.34, 95% CI 0.15–0.61; OR 0.64, 95% CI 0.43–0.95) but at higher risk of underweight (OR 2.57, 95% CI 1.20–6.45). No significant association was found between the traditional pattern and obesity. Moreover, dietary pattern differences occurred due to the differences in socio-demographic characteristics. In conclusion, the modern dietary pattern was positively, and the tuber pattern negatively, associated with general and central obesity among adults in Southwest China

Diet diversity and nutritional status among adults in southwest China.

BACKGROUND:With rapid urbanization in the past decades, diet diversity continues to increase in China. The present cross-sectional study aims to explore the association between dietary diversity and nutritional status among adults in southwest China. METHODS:This study used data from 2011-2012 National Nutritional Survey in Yunnan Province, southwest China (N = 1105).Data of three consecutive 24-hour dietary recalls were used to calculate dietary diversity scores (DDS) and nutrient adequacy ratio (NAR). Body mass index and waist circumference were used to determine nutritional status. Surveylogistic procedure of SAS 9.2 software was used to examine the association between DDS and obesity by estimating odds ratio (OR) and 95% confidence intervals (CI). RESULTS:The mean DDS was 5.2 (SD 1.1) out of nine points. Being female, younger age, belonging to Han ethnicity, having higher educational level and household income were positively associated with DDS (all P<0.05). As DDS increased, consumption also increased in most food groups except grains and vegetables. People with medium and high DDS (DDS = 5 and DDS ≥6, respectively) ingested more energy than the recommended quantity(NAR = 1.1 and 1.2, respectively). However, the intakes of Calcium and Vitamin A were seriously inadequate even for people with high DDS (NAR≤0.5). With potential confounders adjusted, people with medium and high DDS were at higher risk of general and central obesity than people with DDS ≤4 (OR = 1.4-1.9, P<0.01). CONCLUSIONS:Our data indicated that high DDS was associated with excessive energy intake and obesity among adults in southwest China. Although dietary diversity is widely recommended, public health messages should give less emphasis on dietary diversity