Extract bookspekerjaan

I'm looking to employ a freelancer to setup a chatGPT on my Windows local PC. This AI model will be used to extract information from multiple PDF files stored on my computer. Expertise in AI and experience working with chatGPT is essential for this task. In addition, if you have a background in AI, chatGPT implementation, PDF processing, and are proficient in Windows, consider bidding for this project. The end goal is to have a fully functional chatGPT on my local PC that performs efficient and accurate extraction from numerous PDF documents.

I need of a proficient PHP developer to build a script that can scrape textual content from a website protected with Cloudflare. To clarify, I am not seeking to extract any images, links, or other data types - only text. What I need to get: code php with curl or other method Ideal Skills & Experience: - Experience in creating PHP scripts - Knowledge on bypassing Cloudflare protection - Expertise in web scraping

I'm looking for an experienced developer to enhance my data interaction capabilities by integrating ChatGPT with my MySQL database to seamlessly extract customer information. **Requirements:** - Connect ChatGPT to a MySQL database. - Develop a system for text-based chat command retrieval of data. - Present extracted data as a plain text summary.

I'm seeking a seasoned writer deeply familiar with the travel industry to craft engaging blog post...our travel gear in compelling ways. Key Needs: - Produce travel-related blog content - Write enticing product descriptions - Occasionally develop e-book material Skills Required: - Proven track record writing in the travel niche - Ability to mesh product features with travel stories - Flair for creating catchy, share-worthy blog posts - SEO proficiency enhances reach - Experience crafting e-books is a bonus Include in Application: - Showcase your experience, especially with travel writing - Highlight your ability to engage and inform readers - Share links or samples of related work Ideal candidates will have a knack for storytelling, marketing savvy, and a passion for roa...

...expertly handled and made easily viewable and listenable outside of the platform. I have exported the data but cant change format it to be able to view this content Ideal Candidate Skills: - Experience with Telegram API or similar data extraction tools - Proficiency in data manipulation and formatting - Knowledge of multimedia file conversion - Strong attention to detail Project Requirements: - Extract videos, voice messages, and photos from exported data from Telegram - Ensure the content is viewable and audible in a common environment (e.g., standard media players) - Organize files in a logical manner for easy navigation and access - Provide a walkthrough or guide for accessing exported content To succeed in this project, you should have a track record of working with vari...

I'm looking for an expert to extract phone numbers across various platforms for my business needs. Here's what I'm aiming for: - **Data Extraction Goals:** - Collect phone numbers from: - Company websites - Online directories - Social media profiles - **Required Skills:** - Proficiency in web scraping tools and software - Familiarity with data extraction from diverse web platforms - Understanding of ethical scraping practices - Ability to organize data into usable formats - **Ideal Experience:** - A background in data mining - Experience with social media scraping - Previous projects involving contact information collection This data will fuel our business outreach, so accuracy and adherence to legal and privacy standards ...

...demographics of our target customers to tailor our approaches. - Competitive Analysis: - Evaluate competitor product offerings to identify gaps. - Comprehensive examination of competitive landscape for strategic positioning. - Pricing Strategy: - Conduct pricing and cost analysis for competitive edge. - Leverage insights to inform our pricing model. - New Product Insights: - Extract actionable intelligence for potential new product development. - Balance innovative concepts with practical market demands. Ideal Freelancer Traits: - Experienced in market & competitive research, especially eco-friendly products. - Skilled in data interpretation for actionable business strategies. - Efficient in synthesizing findings into concise reports for dec...

I am seeking a proficient data scraper with substantial experience in various forms of online data extraction, particularly from social media platforms like Facebook. Main Tasks: - Extract and compile datasets from 38 universities posts on Facebook together with customers' reactions (like, share, etc as numerical variables) Ideal Skills: - Proven track record in data scraping. - Familiarity with the Facebook API, or other social media scraping tools. - Proficiency in preparing and compiling Excel files from large data quantities. The deliverable of this project is an organized Excel or csv file containing all the scraped data. In performing this task, adherence to guidelines regarding permissible data scraping is paramount. If you code or provide software, its user-frien...

We are seeking a skilled and creative graphic designer to undertake the graphic design and layout editing of our upcoming eBook titled We are looking for someone who can bring our content to life thro...resonates with our audience. Scope of Work: Design a captivating eBook cover that aligns with the theme and content. Format and layout the entire eBook, including the incorporation of any charts, graphs, and images provided. Choose suitable fonts and design elements that enhance readability and engagement. Ensure the final layout is compatible with major eBook platforms (e.g., Amazon Kindle, Apple Books, etc.). Deliver the eBook in both word, ePub and PDF formats Our budget for this project is 40-80 usd . We are open to discussing your rates based on the scope of work and your e...

...targeting car dealerships and corporate fleets within the local area. Your mission will be to use your skills and experience to tap into online directories and generate a robust list of leads. What I expect from you: - Strong communication skills for effective cold calling - Proven track record in lead generation, particularly with car dealerships and corporate clients - Ability to navigate and extract information from online directories - Self-motivated and result-oriented approach - Preferably with insights into the local auto industry market The right freelancer for this job will have: - Experience in B2B sales or telemarketing - Familiarity with the auto services industry - Advanced research capabilities - Commitment to reaching target goals With your expertise, my service...

In my endeavor to create an engaging, fun and educational phonics book for pre-school children aged 3-5 years, I'm seeking a talented illustrator with a knack for hand-drawn style of art. Your creativit...that will stimulate the mind of a preschooler - A consistency in your style across all the pages of the book - Ability to adhere to project deadlines Ideal Skills: - Proven experience in children's book illustration - Strong portfolio showing a variety of hand-drawn illustrations - Knowledge of children's educational books is a plus, but not required When applying, please: - Provide examples of your previous work, particularly any hand-drawn illustrations for children's books Looking forward to collaborating with you to create a phonics book that will...

I'm looking for a talented Python developer who excels in extracting insights from complex data sets. This project revolves around the Betfair platform, requiring a blend of analytical prowess and development skill. Key Requirements: - Extract and analyze betting data from Betfair. - Should be able to transform the JSON data to CSV - Create compelling visualizations utilizing Plotly or other tools Ideal Skills: - Proficiency in Python programming. - Extensive experience with data analysis. - Expertise in Plotly for data visualization. - Familiarity with online betting platforms, particularly Betfair, is a bonus. - Knowledge of PowerBI is an advantage but not mandatory. Freelancers should be ready to showcase their previous work related to data analysis and visualization, ide...

...should cater to three types of users: - **Student Accounts:** Enable students to check in, view their attendance records, and receive notifications. - **Teacher Accounts:** Allow teachers to manage attendance, send notifications, and review student attendance data. - **Admin Accounts:** Grant administrative personnel the ability to oversee and control the entire system, manage user accounts, and extract attendance reports. Ideal candidate skills: - Proven experience developing location-aware and Wi-Fi-enabled mobile applications. - Strong knowledge of iOS and Android development environments. - Familiarity with push notification services and integrating them into mobile apps. - Experience in creating and managing user-specific account functionalities. - A solid understanding o...

We are looking for a programmer who can create a subjective survey analysis program. The goal is to summarize the key findings from the entire survey in a few sentences. Key information: - The survey results are published in Korean. - Summarizes areas such as suggestions and policies for education unions. - All analytical tools are welcome to extract meaningful insights. - I would like to know how many similar types of survey questions there are and summarize the contents.

I am seeking an experienced data analyst to delve into the core of my project, analysing interview data to extract meaningful insights. The successful candidate will ideally: - Have experience with interpreting patterns, trends, and themes from large qualitative datasets. - Be adept at using NVivo software for qualitative data analysis. The project will rely heavily on this software, so proven ability to operate it is a must. - Use the findings to provide actionable recommendations which will guide further project actions. For your application to be considered successful, kindly detail your experience with data analysis, especially if you have worked on similar projects before. Your experience handling similar work will be instrumental in ensuring the successful completion of thi...

Project Description: We are seeking someone to develop an application that is capable of processing, comparing, and splitting large text files. The primary functions of this application will be to: Compare Two Large Text Files: Compare an older database (text file) with a newer one (each containing approximately 1-2 million entries), and identify entries unique to the newer file. Data Extraction: Extract these unique entries and export them into an Excel file. Data Splitting: Additionally, provide a feature to load a single large text file and split it into multiple Excel files, each containing an equal portion of the data (e.g., if a text file has 2 million entries, create 10 Excel files with 200,000 entries each). Key Requirements: Data Processing Capability: Efficiently han...

I need a data analyst for my medium-sized dataset, between 1GB and 10GB, derived from a survey. The scope of work will involve: - Data cleaning and preprocessing to ensure data quality and readiness for analysis. - Data visualization utilizing relevant and informative plots and charts. It's paramount to be able to communi...utilizing relevant and informative plots and charts. It's paramount to be able to communicate the results clearly and visually. - Statistical analysis to provide insights, trends, patterns or any relevant findings in the data. Fluency in data cleaning, visualization tools, and statistical software is expected. Previous experience with handling survey data would be a major plus. The goal is to extract meaningful information from the data that will aid...

I have a bunch of image file witha lot of items in each file in a specific folder. I need help to extract all the JPEG images from these files. It's critical that the image's quality remain intact during the extraction process. Key tasks: - Access and navigate the specified folder or directory - Extract all JPEG images from Word, PDF, and PPT files - Ensure no loss of image quality during the extraction process Ideal Skills: - The person should have experience with data extraction - A strong understanding of different file formats (Word, PDF, PPT, JPEG) - Attention to detail is paramount to avoid unnecessary revisions or back and forths. there is 19 image file and inside each one there min 4 items i need each item alone and all must have a serial number from 1...

I'm in need of a meticulous freelancer to efficiently extract numeric data from existing databases and structure it for analysis. Here's what the job entails: Around 1500 small files in CSV need to be downloaded and collected into two csv files

Seeking a professional to perform an in-depth analysis on the operational costs related to the books spending for my condominiums. I am primarily interested in a detailed expense tracking on a monthly basis. As an ideal candidate, you would have: - Proven experience with Financial Analysis, specifically with Operational Costs - Proficient in the use of expense tracking tools - Strong attention to detail with the ability to spot trends and anomalies - An understanding of property management or real estate industry would be a plus Your work will entail: - Month-by-month tracking and analysis of operational costs for my condominium projects - Providing detailed and informative reports on the spending patterns - Offering practical suggestions on cost efficiency based on your findin...

...4. **Security:** - Implement security measures to protect user data and ensure secure transactions. 5. **Performance:** - Optimize the software for efficient performance, especially during peak usage times. 6. **Compatibility:** - Ensure compatibility with different operating systems and browsers. ### Technical Requirements: 1. **Web Scraping:** - Use web scraping techniques to extract information from the VFS Global website. 2. **Browser Automation:** - Implement browser automation to simulate user actions on the website. 3. **Data Encryption:** - Employ encryption mechanisms for secure data transmission and storage. 4. **Logging:** - Implement a logging system to track user actions and system activities. 5. **Error Handling:** - Include error-han...

I'm seeking an experienced data scraper to collect specific text data from a website and present it in CSV format. Compan...Good understanding and knowledge of CSV data file structure and formatting. - need all 29908 data until tomorrow morning Skills & Experience: - Experience in data scraping is essential, particularly text data. - Proven experience working with CSV file format. - High level of accuracy and attention to detail. - Strong familiarity with scraping tools and programs. - IMPORTANT to have a tool to extract it automatically because we need them until tomorrow morning. Is an easy job for someone with knowledge and good tools. This project can be made with automated tools and is an easy project and fast time ! Please don't contact otherwise ! READ TH...

I need a PHP website that can: - Extract data from my provided PDF containing astrological symbols. - Display this information in a calendar format. - The calendar should be dynamic, adjusting to show constellations and planetary positions for each day of the year in today and New days Ideal Skills for the Candidate: - Experience with PDF data extraction - Proficiency in PHP and web development - Knowledge of creating dynamic calendar interfaces - Basic understanding of astrology and related symbols (preferred but not mandatory) The successful freelancer will have a back-end development background, with a portfolio demonstrating similar projects. They should be ready to discuss the technical approach to ensure accurate representation of the astrological data in a user-friendly ca...

I'm seeking a freelancer with expertise in data extraction and Excel organization to handle a variety of documents for my project. Here's what I need: - Extract text, numbers, and table content from PDFs, JPEGs, PNGs, and hand-written notes. - Accurately convert and organize the extracted data into Excel, ensuring each originating file corresponds to a unique row in a spreadsheet. - Handle potentially complex data in a structured and error-free manner. Essential Skills: - Data Extraction and OCR (Optical Character Recognition) proficiency. - Advanced Excel knowledge, with experience in data sorting and macros. - Attention to detail and accuracy in data input. - Experience with handwritten note transcription is highly advantageous. The ideal freelancer should have a trac...

I'm seeking a talented data scientist to spearhead a predictive modeling initiative for my website. Here's what I need from you: - Develop a sophisticated predictive model tailored to enhance website user experience. - Extract actionable insights that can drive decision-making and strategic planning. - Provide clean, compelling data visualizations that communicate complex analysis with simplicity. Required skills: - Expertise in Python and associated data science libraries (e.g., Pandas, NumPy, Scikit-learn). - Proven experience in building predictive models. - Ability to communicate complex data in a clear and effective manner. - Experience with web analytics is a plus. Ideal candidates will possess a strong portfolio showcasing previous predictive modeling projects, ...

I am in immediate need of a seasoned data engineer with proven experience in Azure, Spark, and Python to assist with a critical data analysis project. Here’s what you’ll be diving into: - Data Ingestion: Implementing robust mechanisms to ingest data into Azure. - Data Transformation: Applying transformations using Spark to prepare the data. - Data Analysis: Conducting deep analysis to extract actionable insights. Ideal Skills: - Proficiency in Azure cloud services - Expertise in Apache Spark for big data processing - Strong programming skills in Python - Experience with data modeling and processing - Ability to document and communicate findings clearly This project requires someone who can ensure efficiency and accuracy. If you have a proven track record and the neces...

I'm seeking an expert developer to help me customize a Google Maps extraction tool. Here's what I need precisely: I want to sell this tool let me know How can I sell or You want to purchase I can give you free demo - **Functionality:** - Extract specific details from Google Maps: - Business addresses and coordinates - User reviews and ratings - Business website URLs - **Compatibility:** - Should work seamlessly on Windows operating system - **Output:** - Data exported and populated neatly in a CSV file - **Skills Required:** - Proficiency in data scraping tools and software - Familiarity with Google Maps API - Strong understanding of CSV file manipulation and output - Capability to develop friendly GUIs for Windows - **Experience:** - Past...

We are a Start Up Electrical Company. Using Zoho one. We would like a bookkeeper/ Business Admins To helps us keep our books in order. Entering Expenses, Sales into our accounting Software ( Zoho Books) This is a startup and we do not have lots of transactions yet, I want to hear from you if you have contractor bookkeeping / Accounting experience. Send me what you charge and what's included in the package and what you know about Canadian Taxes in B.C ( British Columbia)

...freelancer to help transcribe and format my collection of over 20 lyric poems for a book intended to captivate poetry aficionados. - Ideal Candidate Skills: * Proficiency in typing and transcription * Experience with creative writing or poetry * Keen eye for detail and layout aesthetics * Excellent as regards spelling, grammar, and punctuation * Familiarity with publishing formats for poetry books * Good communicative abilities for clear, concise collaboration - Project Requirements: * Accurately transcribe my handwritten or typed poems. * Format for print, maintaining consistent style throughout. * Offer suggestions for layout if needed, enhancing reader engagement. * Work within the set time frame for smooth publication process. - Additional Information:...

I'm seeking a skilled app developer proficient in iOS with optional experience in Android platforms. looking to upgrade following app ( see youtube ) we will provide images (may be pdfs) and sound files. I need to redevelop the app for IOS, current one is pc version If you can do 1 demo page in your reply. Preference would be to select app that...proficient in iOS with optional experience in Android platforms. looking to upgrade following app ( see youtube ) we will provide images (may be pdfs) and sound files. I need to redevelop the app for IOS, current one is pc version If you can do 1 demo page in your reply. Preference would be to select app that allows changes (to fix bugs) and add new books.

Looking for a reliable and informed ghostwriter to tackle a 100-page book about Genesis. Will hopefully be releasing many future books about other books of the bible too. The book will unpack the book of Genesis for Millennials.

Developer to create software for PC that automates the extraction of textual data from static-format PDF files. This data then needs to be exported into an Excel file. Data needed is highlighted in "DocumentX" The plain file (as the application will work with) is "DocumentW" The fields needed are: File Name, Account Number, Billing Period, Start Date, End Date, CCF, Thermal Factor, Therms, Total Usage Charges

Extract text data from a PDF file and to structure this extracted text into an Excel format. I need in excel, the highlighted fields. I am including the plain pdf (documentW) and another with highlighted fields for your understanding (documentX)

PLEASE DON'T SEND LOW PRICE JUST TO DISCUSS I DON'T HAVE TIME I have about 190 photos, on each one there are about 50 emails. I need you extract all emails and you put on a gsheet. All email have same confirguration : @company.c.. So in an other colum you will have to put the first name and the last without the dot between but with a space.

I'm seeking a skilled individual for a data scraping project. Here's what you'll be working on: - Extracting critical fields including: -...and phone numbers - Church ID, Conference, and Standing - Targeting two distinct sections from the database, totaling approximately: - 7500 records from one section - 5000 records from another For this project, you'll need: - Experience in secure, authorized data scraping - Ability to handle textual and numerical data - Proficiency in managing large datasets - Know-how to navigate and extract from subscription databases (credentials will be provided) This role is perfect for someone who has a keen eye for detail and maintains strict confidentiality standards. Please apply if you have a proven track record in d...

I'm seeking a skilled developer to create a specialized C# application with the ability to identify and extract UPC barcodes from images or scanned documents. This application will serve as a crucial tool for our inventory management processes. Here's what I need: - The application must scan images or scanned docs for the presence of any UPC barcodes. - If a UPC barcode is found, the application should parse the UPC. - In cases where multiple UPCs are found within the same file, all UPCs should be returned. - The extracted UPC barcode data should be presented in a plain text file format. Ideal Skills and Experience: - Proficiency in C# programming with experience in image processing. - Previous work with barcode detection or optical character recognition (OCR). - Abili...

I'm seeking an experienced data scraper to collect specific text data from a website and present it in CSV format. Company Bussines Data from: https://www...Good understanding and knowledge of CSV data file structure and formatting. - need all 29908 data until tomorrow morning Skills & Experience: - Experience in data scraping is essential, particularly text data. - Proven experience working with CSV file format. - High level of accuracy and attention to detail. - Strong familiarity with scraping tools and programs. - IMPORTANT to have a tool to extract it automatically because we need them until tomorrow morning. Is an easy job for someone with knowledge and good tools. This project can be made with automated tools and is an easy project and fast time ! Please dont ...

I need someone who is familarized with facebook, facebook ads, facebook api, facebook graphql Do not apply if you don't have knowledge about above mentioned requirements I need someone to create a marketing tool that will extract the ads from facebook marketplace and filter them by sponsored / boosted / normal Note that I don't need someone who can extract the marketplace ads, I can do that myself, I need them to be filtered by sponsored / boosted / normal

Extract values from the following website into the attached spreadsheet

I'm looking for a skilled freelancer who can efficiently scrape an electronics webshop for comprehensive product data and organize it into an Excel spreadsheet. Here's what you need to know to submit a proposal: - Desired Data: - Product categories, su...- Can provide a detailed approach to the project - Additional Notes: - I'm still deciding on the specific webshop - The scope may vary based on my final selection - Ensure you have legal rights to scrape the chosen website Please include in your application how you plan on approaching this task, any similar past projects, and confirm that you have the legal knowledge and capability to extract data without violating terms of use. Your experience should highlight your technical skills and ability to deliver o...

My business receives court records monthly. We extract the names and mailing addresses from these court records. All of the courts format the records differently. Some are in excel, some pdf, some word, etc I need someone who can extract the names and mailing addresses from all of the court records - and put them in one excel spreadsheet. Rarely do people even read the job description - so please put the words 'radar data' at the top of your response so I know you have read the description. I will not respond otherwise When you bid, you are bidding on a small project of around 15-20 court records. For a total of 3,000 - 4000 names. The court records arrive the first part of every month, and need to be completed in about 3 days.

...comprehensive review and fix of this workbook; * Check and repair as needed formulas and utilize conditional formatting to streamline tasks. * Check and repair or add macros to perform complex or repetitive tasks efficiently. - Enhanced capabilities of existing pivot tables; * Effectively consolidate data from multiple sheets for more cohesive reporting. * Employ advanced calculations to extract deeper insights from datasets. What I'm expecting from you: - Proven expertise in Excel, especially with pivot tables and data analysis tools. - Strong background in VBA for macro development. - Keen eye for detail and a knack for data organization. - Ability to deliver a user-friendly interface that simplifies complex processes. - Creative problem-solving skills and a...

I require a proficient freelancer who can extract specific information from a website and translate it into an Excel file for me. The information required includes bank names, their contact information, and their branch locations. The expected outcome is an excel file where bank names, contact information, and branch locations are provided in separate columns. The URL for the website will be provided at the commencement of the task. Ideal skills suited for this project include: - Proficiency in data extraction - Experience with Excel and data organization - Detail-oriented - Understanding of bank related terms and terminologies Can't wait to work with the right talent to effectively execute this task.

I'm on the hunt for a skilled professional who can create an automation program tailored to web scraping. - Target Website: The program must be designed to scrape data from one specific website that will be provided later. - Type of Data: I need to extract both text content and metadata from this site. Precise, complete, and structured data extraction is a must. - Detailed Info: The most critical elements to be retrieved from this data include product names, prices, descriptions along with various other pieces of information. All information to be extracted to Excel spreadsheet. See information detailed Information in the Excel document.

1. Finalising contract, track signature 2. User dashboard and long term tenant invoices and management 3. Email invoices, and invoice cancellations 4. Lead cleaning up old CRM data and fields and automations 5. Zoho Desk sync 6. Deals automations -> update the link in Suggested Improvements -> instead of as a pdf can we send it as a website link to view online? -> Add Delay to send the Offer Details email -> Deal value * duration = total contract value -> Duration = years * 12 -> Estimated earnings - quote = deal value

I require a skilled freelancer to help convert ONIX for Books 3.0 XML files either:- - into CSV format for importing into a SQL database; or - directly into a SQL table The zipped files are downloaded to local PC via MFT. Key Requirements: - Extract ALL data fields including: - Title and author details - Pricing and availability - Full product descriptions and categories - etc. - Ensure all information from ONIX is captured Inputs & Outputs Inputs - XML 3.0 Additions file - (lists new products) - file name format = (N) - XML 3.0 Update file - (lists changes to existing products) - file name format = (N) - XML 3.0 Deletions file - (lists ISBN's no longer available) - file name format = '(N) Outputs - Separate CSV ...

You would play an integral part in an SQL Server Integration Services project, focusing primarily on ETL (Extract, Transform, Load) processes. Key Responsibilities: - Manage a wide variety of data sources involved in this process; this will include database tables, Excel spreadsheets as well as CSV files. - Carry out necessary data transformations such as data cleansing, aggregation and formatting. I'm keen to engage with individuals experienced in data handling, data transformation and SQL Server Integration Services. Proficiency in working with various data sources like database tables, Excel, and CSV files is critical. Additionally, anyone with a background in data cleansing, aggregation and formatting would be highly desirable. The job requires meticulous attention to de...

I need a custom script developed for Windows environments. This project will require detailed knowledge of the Windows registry. The script should be able to capture and export values from specific registry hives. Requirements: - Extract from HKEY_CLASSES_ROOT, HKEY_CURRENT_USER, HKEY_LOCAL_MACHINE. - Target keys: SoftwareMicrosoftWindowsCurrentVersion, SoftwareWow6432Node, SoftwarePolicies. - Document output in a readable format, e.g., CSV or JSON. Ideal Candidate: - Proficient in scripting for Windows OS. - Experience with Windows Registry operations. - Able to create scripts with user-friendly outputs. Deliverable: - A reliable, fully-tested script meeting the above specifications. - Simple instructions for deployment and use of the script. Please provide previous work e...

I'm in need of a professional who can successfully and meticulously scrape text data from a Remote Desktop Connection. Key Responsibilities: - Extract data from a specific Remote Desktop Connection - The data that needs to be extracted is solely text - Expertise required in handling and carefully treading through RDC; mishandling of the process can lead to inaccurate or missing data. - Cant' install anything on the RDC machine FYI. Expectations: - The scraped data should be clean and accurate, reducing post-scraping clean-up work. - The extracted data should be organised and delivered in a CSV format or Json. We will add it to a Mysql DB. Ideal freelancer should have: - Extremely high attention to detail - Proven experience in data scraping, particularly from RDC - Mast...

need a tool using ms access where teams can fill their data from different different location and we can get extract in one excel (excel format is fixed) resources need to put their remarks in specific columns