How to open csv file with more than 1 million rows jobs

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I'm seeking a professional who can help me with pre-employment vetting specifically focusing on employment checks. Key Points: - I need a comprehensive employment verification report for potential employees. - The report should include basic details such as dates of employment and job titles. Ideal Skills and Experience: - Proven experience and expertise in conducting employment checks. - Attention to detail for ensuring accuracy in the reports. - Excellent communication skills to facilitate smooth interactions with past employers. - Strong understanding of employment laws and regulations.

I have collected the dataset in CSV format and now require an expert to develop a multi-class logistic regression model for me. Key requirements: - The dataset is ready and available in CSV format which can be used for the model. - You should have expertise in developing logistic regression models for multi-class classification. - Proficiency with Python is a must as I prefer the model to be developed using this language. Technical Requirements: Proficiency in Python and familiarity with libraries such as NumPy, Pandas, Keras, and TensorFlow. Knowledge of statistical learning, logistic regression, and gradient ascent optimization. Ability to write clear and concise documentation and well-commented code.

I meant to erase one page and save it but I erased all of it and saved it. It still says 15KB. Also see attachment. The file name at the bottom is it.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

Hello, I need fil a CSV with the Amazon categories in French

I need a Python script that can batch process text overlay onto images (jpg/png). All the images and all the text will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images. I would like to be able to change the font style, size, the position on the image, and to have the text be able to wrap to the next row on the image.

Please Sign Up or Login to see details.

Please develop a Python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should specifically target restaurants that have a phone number but *without* a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (meters) - Restaurant Type (including catch all types in the "Food and Drink" category) Key Data to Retrieve, output in a .CSV: - Name - Address - Phone Number - Google Maps URL Ideal skillset: - Proficient in Python - Strong experience with Google Maps/Places API - Ability to deliver results promptly and efficiently - Attention to detail to ensure accurate data retrieval

...a year to bring you a top-notch learning program with Freelancer.com that was never revealed before… It's not just about teaching you everything I know and sharing my journey to the #1 amongst 70 million people; it's also about connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months that...

I have a photo of a medal that I would like to have converted to a svg file for printing. I want the outlines of the kings head, text and contours in black. Also the clasp with the text *1858 Gustaf V †1950 in black. The ribbon should be black also. Show examples and the best one gets the job.

I need a skilled Web Scraping specialist to write code in Python (preferably) that scrapes a specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're

...(see screenshot) - displays rows of 5 thumbnails (similar to Instagram) (see screenshot) Post A post can take 3 forms: - static weight text (ie. 71.3, ^0.5 - where the latter is the weight gained compared to the previous logged weight) (see screenshot) - a photo (see screenshot) - date (ie May 19) (see screenshot) Post interaction - Posts can be deleted or be created Gallery conditions - Displays rows of 5 thumbnails (see screenshot) - If it is the first post of the day, the gallery adds a thumbnail of today's date before adding the actual post (see screenshot) Post condition static weight text - If the weight is equal to the previous logged weight (or if it is the first weight), give it an orange background color (see screenshot) - If the wei...

I need a VRBO scraper to extract property details, pricing, and availability. - The scraper should be built with Python and the output should be in CSV format. - The data points I need include property title, description, amenities, pricing, and availability. - The scraper should be able to handle multiple URLs at once. - The code should be well-structured and commented for easy maintenance. Ideal skills: - Proficiency in Python - Experience in web scraping - Understanding of VRBO website structure - Ability to handle and store data in CSV format

I need a web scraping professional to create a script to extract specific data from , a popular online marketplace for trading cards, please check attachement to get the idea. Key Requirements: - Scrapping: The primary task is to scrape the following information from the platform: - Card properties 1. Hero score for last 7 days 2. Hero rank for last 7 days 3. Stars 4. Rarity 5. Name 6. Quantity listed to purchase 7. Inflation data 8. Minted count - Buy prices List Price Last Price Order book (price and quantity see picture attached) - Bidding details bids book (bid and quantity see picture attached) - Twitter activity per card View Views+ Likes Likes+ Retweets Retweets+ Replies Replies+ Quotes Quotes+ Bookmarks Bookma...

I'm seeking an expert audio ...engineer who can produce a high-quality WAV sound format file that records music in gigabyte quality. The resulted file needs to be compatible to play on various platforms including but not limited to YouTube, Spotify etc. Specifics: - The file should offer unlimited recording capability, with no restrictions in terms of length. - Must possess proven experience in music editing and file formation. Skills in working specifically with WAV formats is a plus. - Familiarity with audio quality requirements for various platforms (YouTube, Spotify, etc.) is crucial. The importance of quality, compatibility, and versatility in this project cannot be overstated. Applicants should bid with...

I have a PDF membership directory that was emailed to me. I need someone skilled in data extraction to help convert it into an easily readable CSV file. The ideal candidate should possess: - Proficiency in working with both PDF and CSV file formats. - Strong data extraction skills. - Attention to detail for data accuracy. Each member listed per row with the perinate contact information separated into its own cells ie: entity/last name/first name/address/ste#/city/state/zip/office ph/email/cell ph The task should be completed by 5/23/24.

I'm in need of an expert to help me create a 3D STL file for a wood carving project I'm planning to run on my CNC machine. Key Requirements: - The 3D model should be suitable for wood carving, ensuring it's conducive to the CNC machine's operation. I use vetric aspire and the file is for a wall decor - I'm looking for detailed, intricate designs that would look appealing once carved. Ideal Candidate: - Proven experience in creating 2.5D and 3D STL files for CNC wood carving. - Proficiency in understanding the constraints and requirements of CNC machines. - Creative and skilled in designing intricate patterns and shapes. - Strong attention to detail to ensure the final product is of high quality and visually appeal...

I have a Turkish language file to assist with the interactive dialogues in my game but it needs a bit of a revamp. Key Requirements: - I need the content to be better organized. Currently, it's a bit all over the place and I need a structure that makes it easier to integrate into the game. - The language file should be targeted towards an intermediate level of Turkish language proficiency. The translations need to be accurate and appropriate for this level. Ideal Skills and Experience: - Proficient in Turkish language, especially at an intermediate level. - Experience in localization and translation for games - Familiarity with file organization and structuring I'm looking for a freelancer who can help me improve t...

...looking for a skilled copyrighter to create blog articles for our website. Here I'm interested in three articles 800-1000 words each - feel free to make more engaging titles: 1. "Technologies and Frameworks Used in Online Banking Software" 2. "Benefits of building custom virtual wallet solutions into your product" - here to speak about features of virtual wallets, flexibility to convert credits in exchange for additional services, etc. 3. "Compliances and certifications that might be needed for a financial services startup" - explore main compliances for the US and European countries a fintech software startup should know about. The main goal of these articles is to educate our audience. Therefore, ...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

As a diligent user of Google Drive, I'm seeking a proficient deve...user of Google Drive, I'm seeking a proficient developer who can create a program using Google App Script to arrange my Google Drive files in a hierarchical manner. Let's make searching and organization efficient and automated! the specific features I am looking for well be explained in private The ideal freelancer for this project would have extensive experience with Google App Script and an understanding of how Google Drive works. You should have created similar file management tools previously, and have a knack for creating user-friendly interfaces. Efficiency is key, as is the ability to work on a tight timeline. I look forward to working with a proble...

Based on a specific Management zone

I'm seeking an experienced data scientist to work on a project to integrate datasets from CSV files with different features, and feed them into various ML algorithms. The primary objective of this analysis will be to classify the data into different categories. The end goal is to determine the efficiency of the different ML algorithms used, which are decision tree, random forest, extra trees, and XGBoost. The perfect candidate for this project would be someone with a solid background in data science, particularly with experience in working with datasets from CSV files and implementing machine learning algorithms. The candidate should also be able to interpret and present results through visualizations such a...

I'm looking for an Android developer to enhance my app to support zip and rar files. The functionality should include: - Support for both zip and rar files - Support for both password-protected and standard files - Ability for users to extract files - Ability for users to view file contents The ideal candidate should have experience in Android app development, specifically dealing with file handling and storage. Knowledge of third-party libraries for handling zip and rar files is a plus. The developer should also be comfortable with implementing password protection mechanisms. Please note that the app is already built, so the task would primarily involve adding the requested functionality.

This is for the new profile view update and you will not be able to view it until the update finalizes and makes this the new normal profile view.

I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.

I'm in need of a skilled freelancer who can perform daily scraping of job titles from Indeed. Ideal Skills and Experience: - Proficient in web scraping, particularly from Indeed - Able to automate the scraping process on a daily basis - Competent in delivering data in CSV format Data Update Frequency: - It's essential that the scraping is carried out daily Delivery Format: - The scraped data should be provided in a CSV file Looking forward to your proposals.

...a year to bring you a top-notch learning program with Freelancer.com that was never revealed before… It's not just about teaching you everything I know and sharing my journey to the #1 amongst 70 million people; it's also about connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months that...

I'm looking for an expert in Fast Fourier Transformation and/or Wavelet Analysis to transform temperature readings into a frequency/bpm output. This project is intended for a research project I am undertaking. I am looking to see if FFT/Wavelets are able to produce acurate bpm readings so there is not definitive method to follow which is why I require your help/ Key requirements include: - Utilizing Fast Fourier Transformation and/or Wavelet Analysis to transform the raw temperature data. (Data is in the form of multiple .csv files with temperature readings and time stamps). Ideal skills for this project include: - Proficiency in Fast Fourier Transformation and Wavelet Analysis. - Strong command of R programming language for generat...

...for a skilled developer to help integrate the DropzoneJS library into my project in full. I have integrated demo vesrion only. The primary goal is to improve the user experience by allowing for drag and drop functionality for file uploads. Key Requirements: - Implementation of drag and drop functionality using DropzoneJS - Ensuring DropzoneJS supports multiple file uploads at once - Do not need integration within the existing project structure. PHP Upload script working just fine. - Adherence to best practices for user interface design and user experience Ideal Skills and Experience: - Proficiency in JavaScript and relevant libraries, particularly DropzoneJS - Proven experience with front-end development and UI/UX design - Ability to i...

I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.

I'm looking to leverage Azure document intelligence prebuilt models and train models to extract data from a variety of tax and financial documents. The extracted data needs to be exported into a Google spreadsheet. Additionally, I need an interface for users to easily upload these documents. Key Requirements: - Extract data from various financial documents: primarily focusing on Expense reports, W-2 forms, credit card statements, 1099s, and annuities. - Extract specific data from credit card statements such as Transaction amounts, Merchant names, Transaction dates, and also the ability to convert currency and combine rows. - Extract specific data from bank statements like Account balances, Transaction descriptions, and Check numbers. Ideal...

We need someone to generate training data (150 posts) to help us train an AI for our site Needpedia.org. We've already set up a custom gpt through openai that can take input as lists of 'subject, problem, idea', and output completed posts, but you're welcome to use a different AI if you want to. We've even generated a list of prompts to generate such good content, so this should be a very easy project. We just need you to have an AI generate the content and make sure all the details are correct. -that the AI didn't hallucinate anything. Formatting is very basic: Subject posts: a few lines of text and some tags. (subject posts are often placeholders for the more interesting content: problems and ideas) Problem...

...needing to be done. The focus will be on using the Yoast Plugin to enhance Product titles. Increasing the word count of Product descriptions to around 230 words (sometimes creating from scratch using other sites as reference and or using AI to help), then creating search engine title and focus keywords and repairing URL structures if needed. If working through CSV is easier, a data export can be sent with relevant data columns. Key Responsibilities: - Enhancing product descriptions for improved SEO performance - Optimizing meta tags to drive more organic search traffic - Restructuring URLs to align with best SEO practices - Utilizing Yoast Plugin to ensure optimal SEO efficiency for delivery area audience Pl...

Payment for AE file modifications

I need to create alternating colors for rows 19 to 28 and specifically for cells F29, F30, F31, and F32 using fill colors #F2F2F2 which is light gray and #F2F2F2 which is white. There will be a lot of hiding and unhiding of rows for this range and I need a solution that always displays alternating colors despite frequent hiding and unhiding of rows. Can anyone help me with setting up a conditional formatting rule that automatically alternates the row colors, regardless of row insertion, deletion, or hiding? https://docs.google.com/spreadsheets/d/1SwqtiYIrZdO8p6YOxKsOx5MTgE3qQwAajTKIImYWHmE/edit#gid=1503373653

PDF File converted to MS WORD File more than 300 pages Need ASAP

...repositories "" to assist me in setting up and running the demo-k6-operator project on my Mac machine. Your guidance should help me to understand how this project works, which is my primary goal. Key requirements: - Expertise in running and configuring projects from GitHub repositories on Mac machines - Solid understanding of the demo-k6-operator project - Ability to provide clear, detailed instructions and guidance for running the project on my machine - Patience and willingness to explain concepts to help me understand the project better The specific challenge we may face is that I'm using a Mac CPU that is NOT Intel, so experience with this kind of set-up would be a significant advantage. Your support in troubleshootin...

I'm in need of a proficient data scientist who can assist me in obtaining targeted gene expression data from the web-based database Culling specific gene expression characteristics, such as expression levels in different tissues and co-expression networks are the ma...scientist who can assist me in obtaining targeted gene expression data from the web-based database Culling specific gene expression characteristics, such as expression levels in different tissues and co-expression networks are the main focus. I require the downloaded data to be in CSV format. Ideal Skills: - Data extraction capabilities - Familiarity with gene expression databases - Proficient in handling large datasets - Ability to deliver data in CSV format

Hello, I need mapping a CSV that contains many information and put all words in each column

Pentest for

Job Title: Offshore Banking Specialist Responsibilities: • Consult on choosing a bank that meets the requirements of an offshore company. • Interact with banking and regulatory authorities in Seychelles. • Ensure the account opening process complies with international standards and legislation. Requirements: • Experience in the financial sector, preferably with offshore companies. • Knowledge of international banking legislation and practices. • Excellent communication skills and the ability to work in an international environment. • Proficiency in English at a high level.

I need the audio fixed in this short video. Please not robotic AI fix. This is a short real estate video I filmed for a client and there is heavy background rumbling as well as reverb (the inside echo) I have tried using the AI functions in Premiere Pro, but I believe this needs further work from someone who works in audio and not just AI and basic editing tools. I need this done asap!

I need to change the way my web site updates schedules for tv channels. Right now my site scrapes external sites and pickle dumps and returns data to the site. I want a json or csv to upload to updates all channels manually or we can use my admin to update with file.

I need an expert in data entry, cleaning, and data visualization in RStudio. The primary goal of this project is to identify trends in a small dataset (less than 1,000 rows). Ideal Skills and Experience: - Expertise in data entry, cleaning, and visualization in RStudio - Strong understanding of R Programming - Proven experience working with small datasets with missing data - Ability to identify trends through data analysis Please only apply if you have demonstrable experience with RStudio and data analysis. The ideal candidate should be able to extract meaningful insights from data and present them in a clear and concise manner.

...professional to assist me in setting up a Local Area Network (LAN) with the primary purpose of facilitating easy file sharing among a small number of devices, specifically less than 10. Key requirements: - Establish a Local Area Network: The main goal of the project is to set up a local network that ensures a seamless connection among the devices for file sharing purpose. - Secure File Sharing: The network should be configured in a way that file sharing is secure and only accessible to the authorized devices. - Minimal Device Connectivity: As the network is intended for a small group of less than 10 devices, the setup should be simple and efficient without compromising security. Ideal Skills: - Networking Expertise:...

I need a Python developer to create a tool for me that can convert different file formats. Although I did not specify the particular formats, I am looking to convert at least two different formats. The tool should have a user-friendly interface and be able to handle these conversions seamlessly. Ideal skills and experience for this job include: - Proficiency in Python - Experience in creating file conversion tools - Knowledge of different file formats - Strong problem-solving skills - Ability to create a user-friendly interface - Understanding of data handling and manipulation Complete details will be provided to shortlisted candidates.

I'm seeking an experienced tattoo artist who can bring to life a realistic design of an open book with a rose laid on top. The tattoo will be placed on my arm, so it should be appropriately sized and detailed for this placement. Key Requirements: - Design Style: Realistic - Placement: Arm - Color Preference: Both (considering a color and black and white version) Please only apply if you have prior experience in creating realistic tattoos and are comfortable working with both color and black and white designs. Quality and attention to detail are paramount for this project.