The first column is the user names and the following columns match questions (150 columns)
Each line contains a specific user answer to the question written in the column title.
Postgresql has a table with users (each name corresponds to the idy) a table with questions (each question corresponds to the idy) a table with answers (each user - idy question - answer)
You need to write a script on the paton that will add answers from the ixel to the tables with answers.
Есть пивот таблица в икселе
Первая колонка это имена пользователей а следующие колонки соответсвуют вопросам (150 колонок)
каждая строка содержит определенный ответ пользователя на вопрос написанный в заглавии колонки
В бд Postgresql есть
- таблица с пользователями (каждому имени соответствут айди)
- таблица с вопросами (каждому вопросу соответвсует айди)
- таблица с ответами (айди пользователя - айди вопроса - ответ)
Необходимо написать скрипт на пайтоне который добавит ответы из икселя в в таблицу с ответами
Client's feedback on cooperation with freelancer
Postgresql add lines from a table using PythonThank you for help!Everything is great!
Freelancer's feedback on cooperation with Maria Murashova
Postgresql add lines from a table using PythonA great customer. Good tz, fast and decent payment. I recommend cooperation
Profile deleted | Safe
Current freelance projects in the category Databases
Viber community parser
25 USD
write a parser for Viber communities following the example of the parser's work on the website https://promouser.com/ as a result, we get a file with phone numbers of community members Databases, Data parsing |
[TM] BA Analyst - create 30 SQL queries for dataset
120 USD
Good day, there is a dataset consisting of 3 tables, need to create 30 SQL queries for it. Domain - ecommerce 5 simple queries for each table 2 complex queries with aggregations for each table 4 queries for table pairs with aggregation 5 queries for all tables at once I need… Databases, Data processing ∙ 3 proposals |
Web applicationIt is necessary to expand the functionality of the existing web application (TypeScript, React, and Next.js) by adding a fuzzy search module. The databases are large, Elasticsearch or Manticore Search should be implemented for data indexing. Databases, Web programming ∙ 5 proposals |
Loading products into an online store in Wordpress
54 USD
Loading products - wigs and accessories. Variative - 273 products, several photos for each product, + color variations. Non-variative 33 products. Option 1: upload products from Excel document to my Wordpress online store www.wigs.lv, 3 languages. Sample document attached.… Databases, Data parsing ∙ 6 proposals |
Develop a mobile application. Backend + Frontend Android/iOSA design has been developed. An application-catalog with user registration, filters, search, the ability to add to saved and comparison. cracking of requests from the state website (most likely parsing), a feed of recommendations based on interests, push notifications. A… Databases, Hybrid mobile apps ∙ 18 proposals |