I have a txt file (attached) that I am reading as pandas data frame. For each ClassID within a certain SchoolID, I need to look at all the features (i.e. columns F_1 to F_7), and replace each zero value with the average value of its n neighboring grids, within each column. I need to define a searching radius n to calculate the average of those n adjacent
...availability, product information, digital assets). Data comes from different sources (FTP, URL), let's collect it and combine it in a master table. Files are usually XML or CSV. Files can also be compressed (ZIP) in individual cases. Access to the files is usually password-protected. The mapping is specified by us. Does not have to adapt or be editable
I am looking for a freelancer whose seasoned in the field of excel and VBA. The idea of the project is to automate an excel checklist. For example, if a user double clicks on a cell a tick will appear or N/A.I have the general structure of the checklist an other ideas from other projects I have worked on before. I will be more interested in a freelancer
...1. User is clickin of one Imeage (Product ID) 2. Going to Cart with Paypal Smart Buttons (Link 2) 3. Select one Payment-Method 4. Create secure Payment 5. Capture Payment in txt file Link 1: [kirjaudu nähdäksesi URL:n] Link 2: [kirjaudu nähdäksesi URL:n]
we have an ecommerce website [kirjaudu nähdäksesi URL:n] that we need to create CSV feed to get the products on Ebay and Amazon so we need a good developer front and back to do this. the front end developer is Bootstrap whilst the backend developer is Django Oscar.
We have an API response data which is in the complex nested JSON format. We need to write a VBA macro to parse the complex JSON Response data into an easy and understandable format. VBA macro should parse any JSON response data which is in valid format.
...a dermaroller. We need you to design the packaging for the box using the same THEME as the logo, same FONT as the logo etc. (Logo attached). I have attached the text in a .txt file, as well as the logo and packaging. Please ensure you match the correct notepad text file, with the correct packaging outline. We wish the packages to have a *SAME THEME*
...Be able to export all tires in storage into csv or even better xlsx(excel file) A page to be able to export all tires into excel to -------------------------------------------------------------------------------------------- Import / Export page Name says it all a page where I can export everything to csv/excel And where I can import new or override
I need help to understand the Excel VBA and it's usage to to develop a interactive data dashboard.
...in predined bundle: txt file (login + pass) and QR code images. In total there are 200 credentials but we will upload new when the old is wasted. 3. If the user refreshes the page or the link is opened again by somebody else or the same person, he again gets the CAPTCHA and then sees new credentials (the next line from the txt) The user should never
...give you a starting point - [kirjaudu nähdäksesi URL:n] [kirjaudu nähdäksesi URL:n] I will be providing you with a CSV of the Australian suburbs and their corresponding postcodes & regions which I want included in the map. The map will show the regions. If you can please send any example images
...exported to a word doc as the client needs a 1 page report on each property. We have previously used Mail Merge to achieve this. I was wanting to get someone to write some VBA code which will automate the Mail Merge steps. For example there may be a button in excel which says 'Export rows 4 to 11' and it will export each row to Word and populate a
...sql、[kirjaudu nähdäksesi URL:n]。 Use file – [kirjaudu nähdäksesi URL:n] as a specification of data sheet Use [kirjaudu nähdäksesi URL:n] to produce web page Functional requirements description: 1. Load CSV file. 2. Analyse CSV file, use CustomerCode as index，according to all data in row corresponding to the index, same data should be overwrite...
...a few hospitality related businesses and use Excel to integrate with other applications. I have taught myself VBA but am far from an expert and quite often need assistance in solving problems/issues such as the following. I have some VBA code in Workbook 1 to query data in another external workbook (Item [kirjaudu nähdäksesi URL:n]) and it works perfectly. I have
...considerando todas las especificaciones indicadas incluyendo la carga de informaciòn (Value) Debe ser grabado en un archivo sql o txt 3.. Script de poblado de las tablas requeridas. Debe ser grabado en un archivo SQL o TXT...
i require a developer to upload products to our WordPress site. the csv has 100,000 entries which consist of products and variations. I would like these imported correctly. the CSV file will have to be edited as i don't need all the products on there. I have wp scalability pro and w3 to help increase the speed of site. i require the website to have
The task is to align parallelly 2 texts in different languages. In this case it is English and Polish. I will provide you these two texts and software that can ...will be needed for you. An output of your work should be alligned text - two columns of texts. On the left text in Polish, on the right side text in English. Format of file .txt or .xlsx.
Basic Requirements: 1. I have downloaded a huge .csv; that I will apply filters too (based on SIC codes) to produce a list of industry specific UK companies. 2. Scrape Contact data (linkedin /[kirjaudu nähdäksesi URL:n]) for companies identified in the csv file above. 3. Import all company / contact data into a standard template that I will provide (so I can do a batch
I need a project done as part of a daily rec process. I don't think it will take very long but I am getting stuck on how to write the vba code even though I do know some vba myself. Essentially I just need column I (Quantity) to net to zero (once the "sells" have been made negative - this much I can do) and I need the cells in Column H (Period) to have
...the website is to provide a multi-tenant view of a telephone and internet billing system. There's already a developer working on an application to populate the database from csv files. This application is a C# Core console application and will be moved into a windows service. Source code is being checked into a private repo in github that you will have
I have a macro that works great when sending to external users it will prompt before sending. I need this converted to an add on that will work on any computer. I will need source code to modify the file later with correct domain.
Looking for an expert to create a product database and connect directly to an existing WooCommerce website backend. We currently update our product data via a CSV file. We'd now like to develop a product information management database which is linked directly to our site's backend, so it can automatically update our product information based on the
mi serve un prospetto excel in VBA per gestire elementi di contabilità. il prospetto è semplice. evito lunghe descrizioni e allego un documento simile a quello che devo realizzare. Quello che mi serve cambia leggermente ma non è più complicato
Data Wrangling Project: We have product data CSV files that we use for importing into e-commerce websites. We need someone that can take our CSV files and create a simple program that cleans up the data so that it imports cleanly into our platform. We need the description field cleaned up, dimension fields parsed out and logic implemented to break out
Hello, we would need a VBA module that accepts one parameter. This parameter will be a path to a file. The script will the read the file line by line. The file that is passed can be two things, or text, or a list of other files (one per line). If the line is text, it should put it in the email body. If is a file, the script should read the file content
...for professional Python Developer to help me create new data entries using my CSV files on my computer. 1. These files will be in real time. 2. Must be able to debug during project. 3. Must have HIGH RATING 4. Must make a simple User interface to see the values of the csv. 5. Must send a audio/video of you understanding the project to confirm. NO
...2021). For background on the project, please visit [kirjaudu nähdäksesi URL:n] The analyst will primarily be responsible for exporting .csv Twitter data extracts into NVivo or [kirjaudu nähdäksesi URL:n] qualitative research software. Data needs to be ready for coding and analysing URL’s varied uses on Twitter by December. The research
...domain — Web Services (XML, SOAP & REST is mandatory) — Operationally minded to monitor and maintain daily integration feeds — Java/J2EE/JEE — Data formats: EDI, XML, XSL, XSLT, CSV — Superb troubleshooting and data management skills — Incredible attention to detail and passion for clean data — Excellent written and verbal communication skill...
Simple Software to check email validity using a Csv or text document. Fast cpm and can use auth to secure the app, command line tools are fine. Need for client leads contract so prebuilt is fine, or quickly built.
...on customer roles. All article informations should be exported directly from the TecDoc Database into a .csv format, one for every language. We can provide export specifications for the format. Price+availability comes from the ERP as a .csv file and should be imported as a cronjob every day. The identification for the article would be a combination
This file is to be converted from Shopify format to woo commerce CSV . REDAY TO UPLOAD This must take into account variations. You must understand the formats of both shopify and woo commerce before bidding for this work. And must be able to be returned in 24 hours.
Need the following quickly setting up to c...customize a simple PHP inventory system that is written in PHP with MySQL database. Storage Location Details – Location code details for shelf, etc. and import part details from CSV. Setup 5 simple screen layouts for putting away parts – I have layouts for these. Please contact me for full details.
I want the development of a wordpress plugin that can track down the pages a registered user have visited and how long it stayed on each page. The logs must be able ...the development of a wordpress plugin that can track down the pages a registered user have visited and how long it stayed on each page. The logs must be able to be exported to csv file
Need a candidate who has expertise in Android/IOS app scraping and will able to perform certain functionalities: - give the scrape data in csv file - explain briefly about the methodology and tool used - submit the code file
Crear una base de datos con interface web: + 1 Tabla con 5 tablas relacionados a ésta + interface web para poder manipular los datos + interface para subir / bajar datos via CSV + búsqueda + mostrar los resultados de búsqueda en págia web + cuentas para las empresas (para que puedan manipular sus datos de la tabla "Empresa"
Help migrating zendesk knowledge base to Salesforce knowledge. Some python/data transforming might be needed to programmatically update csv and URL paths. Please apply only if you have have experience with Salesforce Knowledge
Necesito editar un archivo CSV para Shopify. Este que me han pasado es incompatible y hay que modificarlo. Busco a alguien que sepa y pueda hacerlo. Por favor, dígame el presupuesto que solicita para esta tarea.
...woo commerce. Only new products. Must have functionality to understand what has already been imported or look at what already has been imported by SKU. Must either produce csv that can be directly imported or import through plug in, after review. Control what times this can be completed or one off. or set timers 2. Import price, sale price, stock
...be improved, better gamma, contrast, and brightness) 7. Send the image to google cloud OCR (Google Vision) Api and get text. 8. Export image to jpg or PDF, the text to plain txt file and Word. 9. Save on Google Drive, OneDrive, Dropbox, device and backend. Share to mail, whatsapp 10. Setting, like Genius App, and multilanguage (english, spanish, portuguese
I have created a student grade report in Excel. I have about 150 students who need their individual student grade report. I have all the gradebook data entered into Excel along with the student grade report. The area I need help in is to have a macro of some kind fill out this Excel tab (student grade report), 150 times. I then want those 150 reports to be converted into a PDF and saved on my ...
[kirjaudu nähdäksesi URL:n] excel data files into a folder 2. Run macro to process all the raw data from the different excel files to place into a text file template -There are multiple Monthly data for multiple ID numbers in each excel file -I want to process only rows that contain dates and only the most current 35 days for each specific ID number 3. Save text file into same folder as ...
hi My onine shop is this: www.Express-Zone.com. It´s Prestashop 1.6 based and I need to migrate to Prestashop 1.7 with same design, products, orders & cust...this: www.Express-Zone.com. It´s Prestashop 1.6 based and I need to migrate to Prestashop 1.7 with same design, products, orders & customers. i have all product information on CSV files. thanks.
...there are other areas to provide a comprehensive analysis, please specify) 5. Produce report that contains important insights from these analysis. Outputs: 1. Cleaned data in csv for all years 2. Dashboards built in Power Bi or Tableau or your dashboard solution of your choice 3. Insight Report based on analysis. Please indicate the cost that you are
I have a data scraper which I used to scrap cricket matches data from crickinfo...it has now stopped working. I need some one who can fix this scrap...cricket matches data from crickinfo...it has now stopped working. I need some one who can fix this scraper ....I will more that 1500 if it starts working again....it's basically a vba SQL based scraper