HiOri

import openpyxl
from openpyxl import load_workbook, cell, workbook
from string import ascii_lowercase
import pandas as pd
import xlsxwriter
from os.path import expanduser as ospath
import xlrd
data1= pd.read_excel('C:/Users/Shaked Bruner/Desktop/GSE72056_series_matrix_shaked.xlsx', sheet_name='Sheet3')
seris_matrix_df= pd.DataFrame(data1,columns=["!Sample_title", "!Sample_geo_accession","!Sample_source_name_ch1", "!Sample_organism_ch1", "!Sample_characteristics_ch1", "!Sample_characteristics_ch1"])
data2= pd.read_excel('C:/Users/Shaked Bruner/Desktop/revised_2.xlsx', sheet_name='Sheet1')
seris_matrix_revised_df= pd.DataFrame(data2)
data3=pd.read_excel('C:/Users/Shaked Bruner/Desktop/participant.xlsx')
participants_df= pd.DataFrame(data3)
new_df={}
for ind in seris_matrix_df.index:
    value1= seris_matrix_df['!Sample_title'][ind] #עוברת על כל עמודה sample title ושומרת את המיקום של השורה הזהה
    for ind2 in seris_matrix_revised_df.index:
        value2= seris_matrix_revised_df['Cell'][ind2] #עובר על כל עמודת cell
        if str(value1) is str(value2):
            #rowForSet= row
            #rowforValue= i
            for column in seris_matrix_revised_df:
                cellValue= seris_matrix_revised_df[column][ind2]
                new_df.update({column:cellValue})