Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Supported by

Merge xlsx data files

Hi!

I have several times 150 csv files for different experiments that were created with open sesame. Due to some errors during datacollection the "subject number" of several files are not correct.

To overcome this issue, I have made xlsx files based on the csv files, I have added a column "Subject" with the correct subject number for each file, and finally added all these corrected xlsx files to **one new folder. **

I want to merge all these files to one big "masterfile". I have tried different options, for example the data merger program. The program indicates it the merge was successful, but once I open the created csv file, it only contains the title cells, without any other data.

Can somebody help? Thanks in advance!

Comments

  • Hi,
    if you know / use R, you could use the read_bulk function from the readbulk package to merge all xlsx files.
    The command would look something like this assuming that you have one folder named raw_data that contains all xlsx files to merge.

    library(readbulk)
    library(readxl)
    dataset <- read_bulk(directory = "raw_data",  fun=read_xlsx)
    

    Best,
    Pascal

  • Hi,
    Thank you very much for your answer. I have tried this and I get this: Warning in read_bulk(directory = "directory", fun = read_xlsx) :
    Final data.frame has 0 rows.

    Unfortunatly, I am not an R expert. Is there another way?

  • Hi Ellion,

    Is your folder with all the corrected files called "directory"? If not, you have to put the correct folder name it in that field.

    In case, this is not the problem, could you upload two or three of the corrected files?

    Eduard

  • Hi,

    I thought it might be helpful to provide a bit more information on the process of reading the data into R (in general and using readbulk in particular). If you read any file into R, R by default looks in the current working directory. You can determine what is the current directory using the following command:

    getwd()
    

    To change the working directory, you can use the setwd() function or, if you use RStudio, you can change it via the menu (Session/Set Working Directory/Choose Directory...).

    It is important that you change the current working directory to the folder that contains the folder in which your files are stored.

    Then you can use the command from above:

    library(readbulk)
    library(readxl)
    dataset <- read_bulk(directory = "raw_data",  fun=read_xlsx)
    

    Where it says "raw_data" you need to enter the name of the folder that contains the raw data.

    Best,

    Pascal

Sign In or Register to comment.

agen judi bola , sportbook, casino, togel, number game, singapore, tangkas, basket, slot, poker, dominoqq, agen bola. Semua permainan bisa dimainkan hanya dengan 1 ID. minimal deposit 50.000 ,- bonus cashback hingga 10% , diskon togel hingga 66% bisa bermain di android dan IOS kapanpun dan dimana pun. poker , bandarq , aduq, domino qq , dominobet. Semua permainan bisa dimainkan hanya dengan 1 ID. minimal deposit 10.000 ,- bonus turnover 0.5% dan bonus referral 20%. Bonus - bonus yang dihadirkan bisa terbilang cukup tinggi dan memuaskan, anda hanya perlu memasang pada situs yang memberikan bursa pasaran terbaik yaitu http://45.77.173.118/ Bola168. Situs penyedia segala jenis permainan poker online kini semakin banyak ditemukan di Internet, salah satunya TahunQQ merupakan situs Agen Judi Domino66 Dan BandarQ Terpercaya yang mampu memberikan banyak provit bagi bettornya. Permainan Yang Di Sediakan Dewi365 Juga sangat banyak Dan menarik dan Peluang untuk memenangkan Taruhan Judi online ini juga sangat mudah . Mainkan Segera Taruhan Sportbook anda bersama Agen Judi Bola Bersama Dewi365 Kemenangan Anda Berapa pun akan Terbayarkan. Tersedia 9 macam permainan seru yang bisa kamu mainkan hanya di dalam 1 ID saja. Permainan seru yang tersedia seperti Poker, Domino QQ Dan juga BandarQ Online. Semuanya tersedia lengkap hanya di ABGQQ. Situs ABGQQ sangat mudah dimenangkan, kamu juga akan mendapatkan mega bonus dan setiap pemain berhak mendapatkan cashback mingguan. ABGQQ juga telah diakui sebagai Bandar Domino Online yang menjamin sistem FAIR PLAY disetiap permainan yang bisa dimainkan dengan deposit minimal hanya Rp.25.000. DEWI365 adalah Bandar Judi Bola Terpercaya & resmi dan terpercaya di indonesia. Situs judi bola ini menyediakan fasilitas bagi anda untuk dapat bermain memainkan permainan judi bola. Didalam situs ini memiliki berbagai permainan taruhan bola terlengkap seperti Sbobet, yang membuat DEWI365 menjadi situs judi bola terbaik dan terpercaya di Indonesia. Tentunya sebagai situs yang bertugas sebagai Bandar Poker Online pastinya akan berusaha untuk menjaga semua informasi dan keamanan yang terdapat di POKERQQ13. Kotakqq adalah situs Judi Poker Online Terpercayayang menyediakan 9 jenis permainan sakong online, dominoqq, domino99, bandarq, bandar ceme, aduq, poker online, bandar poker, balak66, perang baccarat, dan capsa susun. Dengan minimal deposit withdraw 15.000 Anda sudah bisa memainkan semua permaina pkv games di situs kami. Jackpot besar,Win rate tinggi, Fair play, PKV Games