Azure synapse pipelineでのデータ変換について

Question

azure synapseのパイプラインでExcelデータの.xlsxからcsv変換のやり方のやり方がわからないです。Microsoftのドキュメントが分かりにくく理解できないので、画像付きでご教授して頂きたいです。

Converted Japanese => English language:

About data conversion in Azure synapse pipeline

I don't know how to convert .xlsx to csv of Excel data in azure synapse pipeline. Microsoft's documentation is confusing and incomprehensible, so I would like you to teach with images.

Answer 1

Hello @NishimuraChinatsu-9854 ,

Thanks for the question and using MS Q&A platform.

MS Q&A platform is only support question in English language only.

As the question is posted in posted in Japanese language, I had used Google translator to convert to English.

As I understand, you want to convert .xlsx to csv of Excel data in azure synapse pipeline.

You can use pandas to convert Excel to CSV in Azure Synapse Analytics.

The below code snippet helps to convert Excel to CSV:

#importing pandas as pd  
import pandas as pd  
  
# Read and store content  
# of an excel file  
read_file = pd.read_excel ("Test.xlsx")  
  
# Write the dataframe object  
# into csv file  
read_file.to_csv ("Test.csv",  
				index = None,  
				header=True)  
	  
# read csv file and convert  
# into a dataframe object  
df = pd.DataFrame(pd.read_csv("Test.csv"))  
  
# show the dataframe  
df  

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators