Reshape dataframe in R using dcast or ftable

I currently have a data frame that looks like this. country2<-c(“Afghanistan”,”Afghanistan”,”Afghanistan”) continent2<-c(“Asia”,”Asia”,”Asia”) series<-c(‘lifeexp’,’pop’,’gdp’) y1901<-c(‘1′,’3′,’100’) y1902<-c(‘2′,’4′,’101’) y1903<-c(‘2′,’4′,’101’) y1904<-c(‘2′,’4′,’101’) y1905<-c(‘2′,’4′,’101’) y1906<-c(‘2′,’4′,’101’) y1907<-c(‘2′,’4′,’101’) df<-data.frame(country2,continent2,series,y1901,y1902,y1903,y1904,y1905,y1906,y1907) country2 continent2 series y1901 y1902 y1903 y1904 y1905 y1906 y1907 1 Afghanistan Asia lifeexp 1 2 2 2 2 2 2 2 Afghanistan Asia pop 3 4 4 4 4 4 4 3 Afghanistan…

Details

Intermittent database errors when accessing WordPress database

Update: I’ve narrowed this down to a couple of issues that seem unrelated. The testing suite was disconnecting my database without reconnecting. (resolved) The mysqli_free_result(): Couldn’t fetch mysqli_result wp-db.php line 1550 error still pops up for an unknown reason. It seems it sometimes is failing to get a proper result from the query SELECT option_value…

Details

SqlTransaction Zombie error after a timeout

I have a all day running data process running with .NET C# I am getting the zombie error on trying to Rollback a transaction after a timeout occurs: This SqlTransaction has completed; it is no longer usable.|System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable. at System.Data.SqlClient.SqlTransaction.ZombieCheck() at System.Data.SqlClient.SqlTransaction.Rollback() My code : using (var…

Details