Terminé

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 !

Compétences : Python, Excel, Architecture Logicielle, Traitement de Données, Programmation

En voir plus : 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

Concernant l'employeur :
( 63 commentaires ) college park, United States

Nº du projet : #32228204

Décerné à:

(19 Commentaires)
4.8

18 freelances font une offre moyenne de 19 $ pour ce travail

(199 Commentaires)
7.4
(59 Commentaires)
5.7
(17 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(46 Commentaires)
4.5
(36 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(19 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
benjiromiura0917

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0