Đã hoàn thành

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 !

Kĩ năng: Python, Excel, Kiến trúc phần mềm, Xử lí dữ liệu, Programming

Xem nhiều hơn: 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

Về Bên Thuê:
( 63 nhận xét ) college park, United States

ID dự án: #32228204

Được trao cho:

(19 Đánh Giá)
4.8

18 freelancer chào giá trung bình$19 cho công việc này

(199 Nhận xét)
7.4
(59 Nhận xét)
5.7
(17 Nhận xét)
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 Thêm

$14 USD trong 1 ngày
(46 Nhận xét)
4.5
(36 Nhận xét)
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 trong 7 ngày
(19 Nhận xét)
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 Thêm

$10 USD trong 1 ngày
(4 Nhận xét)
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 Thêm

$10 USD trong 1 ngày
(4 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
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 Thêm

$20 USD trong 5 ngày
(0 Nhận xét)
0.0
benjiromiura0917

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

$20 USD trong 1 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
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 Thêm

$20 USD trong 7 ngày
(0 Nhận xét)
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 trong 4 ngày
(0 Nhận xét)
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 trong 5 ngày
(0 Nhận xét)
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. Thêm

$20 USD trong 7 ngày
(0 Nhận xét)
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 trong 2 ngày
(0 Nhận xét)
0.0