Suoritettu

Simple Python / Excel project: Take 2-line address and split into 2 columns

I have an excel file. It has some address that are in one single excel column (cell) but on two lines like this:

3424 Spring Road

Apt 10

I need these types of addresses to be split into 2 columns so that "3424 Spring Road" is in one column and "Apt 10" is in a second column. I need a python script that will take the path of the file (Windows - open a file dialogue box so I can choose the file!) as the input, and then output a new excel file with the additional column. Most addresses do NOT have 2 lines, so the new column in the exported excel file will be blank. But for those addresses that DO have a second line, the new column in the exported excel file will have a value. Make sure you understand this before bidding !

Taidot: Python, Excel, Tietojärjestelmäarkkitehtuuri, Tietojenkäsittely, Ohjelmointi

Näytä lisää: simple excel project grade, simple gui excel, simple medical shop project, excel project manage template web design, simple layout development project, creating simple excel project, excel project simple, excel project timeline simple, simple excel project analysis, building project time line excel, simple excel project input data, simple excel project list, convert simple spreadsheet excel python, simple excel project database, create simple vba excel project, write simple python game project

Tietoa työnantajasta:
( 63 arvostelua ) college park, United States

Projektin tunnus: #32228204

Myönnetty käyttäjälle:

(19 Arvostelua)
4.8

18 freelanceria on tarjonnut keskimäärin $19 tähän työhön

(199 arvostelua)
7.4
(59 arvostelua)
5.7
(17 arvostelua)
5.3
tadinhkien

Greetings! How are you today? Thanks for posting this job. I have checked your project description. ✅I'm AI engineer also Developer and Crawling website with 4+ years experiment.✅ I am very familiar to Deep learning Lisää

$14 USD 1 päivässä
(46 arvostelua)
4.5
(36 arvostelua)
4.3
warlikedhruv

I can get the work done in pyhton3 with pandas and openpyxl , you can share more details of the work in chat

$25 USD 7 päivässä
(19 arvostelua)
3.8
Noman4077

hello there, I have experience in and good grip on python, automation bot and web scraping . I can do your task quickly and in smart budged. I can show you my some pervious work on this. kindly contact me so that we c Lisää

$10 USD 1 päivässä
(4 arvostelua)
3.5
loopsatomic

Hello, If you are looking for some assistance or guidance in python, AI /ML, Backend, Flask, Django, Web Scraping and anything at all, we are the organization you are looking for. Our team has been working in this fiel Lisää

$10 USD 1 päivässä
(4 arvostelua)
2.5
megagradesAEPL

Hi I can help you in this. Eagerly waiting foy you to come in chat box thanks and regards Suman Paul AEPL

$20 USD 1 päivässä
(0 arvostelua)
0.0
naseemakash664

Hai This project piqued my interest because I felt that this was right down my alley. Even though it possesses complex modules, I am positive that I can handle them. Meeting deadlines is one of my talents that surpass Lisää

$20 USD 5 päivässä
(0 arvostelua)
0.0
benjiromiura0917

Hi. I can do it using pandas in a few hours. Can we have a chat to discuss more?

$20 USD 1 päivässä
(0 arvostelua)
0.0
mishragaurav247

I have a great experience working with Python. I have a experience of more than 2 year with python. I have made some great project using python which makes me well experienced with Python.

$10 USD 1 päivässä
(0 arvostelua)
0.0
ankitasarkars112

Hello, I'm a BCA (Bachelor of computer application) student. And i have knowledge on ms office or Microsoft tools like excel , PowerPoint , word etc and also i have worked experience 6th month data entry job. Also i ha Lisää

$20 USD 7 päivässä
(0 arvostelua)
0.0
rishadislam6969

Hi sir, my name is rishad. I can do your job. I hope you will give me the job. I will be able to do your job well. Please give me the job.

$10 USD 4 päivässä
(0 arvostelua)
0.0
kajuteju

I am python developer with 2+ years of experince. I have completed this kind of task. I will deliver the script as early as possible.

$20 USD 5 päivässä
(0 arvostelua)
0.0
durgeshrathod111

i will complete your work without any kind of mistake we are the organisation you are looking for. Our team has been working in this field for a very long time and we have been training a lot of interns in this domain. Lisää

$20 USD 7 päivässä
(0 arvostelua)
0.0
AmnaAsfand

I am hardworking. I work properly and complete my work with given task on time. You dont worry about any thing . 100 % satisfaction work I promise you.

$30 USD 2 päivässä
(0 arvostelua)
0.0