ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '658177' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '658177' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '658177' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '658177' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '658177']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '658177'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 658177 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 658177]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 658177 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 658177

Título del libro:
Título del capítulo: Data-Driven Decision-Making for Product Design: A Descriptive Feedback and Physiological Metadata Analysis

Autores UNAM:
JOSE CARLOS RODRIGUEZ TENORIO; VICENTE BORJA RAMIREZ; ALEJANDRO CUAUHTEMOC RAMIREZ REIVICH;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2024

---

Palabras clave:

Data consistency; Decision making; Human engineering; Metadata; Physiological models; Data driven decision; Decisions makings; Descriptive feedback; Human activity recognition; Metadata analysis; Natural language toolkit; Natural languages; Physiological variable; Sentiment analysis; Design for manufacturability

---

Resumen:

This chapter presents the results regarding the data analysis made for studying the user?s perception and experience when giving descriptive feedback within the product design process. It also includes metadata analysis regarding current trends and technology used for gathering body parameters such as temperature, heart rate, pH, sweat, and accelerations to quantify and compare user interactions during the development of a new product. The data analysis tools used were Pandas, Matplotlib, Numpy, spaCy, and the Natural Language Toolkit (NLTK) for sentiment analysis. For exploratory analysis, word clouds were created. A total of 536 sentences were analyzed, with an average length of 12 words per sentence. Among these, 52% of the total words were classified as verbs, nouns, adjectives, or adverbs, providing information regarding user experience, while the remaining words served to link sentences and give structure. The sentiment analysis showcased that 54.8% of the sentences provided a positive or negative connotation regarding the user?s experience. In comparison, 45.2% were neutral sentences, providing no information regarding the user?s perception. It is up to the design team to map and classify these comments into engineering requirements based on their experience. The metadata analysis showed the most studied physiological measurements for human activity recognition (HAR) and how the combination of these variables has been studied to quantify user feedback and improve the design process. Human data collection and study of two or more of these variables is helpful for providing designers with an additional tool for descriptive feedback that could improve decision-making. © The Author(s), under exclusive license to Springer Nature Switzerland AG 2024.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9783031674396
Editorial:
Springer Science and Business Media Deutschland GmbH

Tipo de producto:
Conference Paper

DOI:
10.1007/978-3-031-67440-2_6