Dear all,
I have hourly soil temperature data estimated as different depths and I want to produce a heat map of the data using ggplot2. The soil depths are not at equal intervals.
A sample dataset is as below:
indata <- structure(list(X10.000000 = c(5.607881, 4.58506, 3.823699, 3.091595,
3.169322, 3.050621, 2.971773, 5.25187, 7.231735, 9.686256, 16.426731,
20.356164, 18.288941, 14.251777, 15.637603, 19.620009, 20.198762,
13.947759, 10.570585, 8.630218, 7.351892, 6.442327, 5.699504,
5.104255, 4.564272, 4.164917, 3.867756, 3.567557, 3.256465, 3.064347,
3.018915, 3.224133, 8.484593, 13.399714, 17.941652, 21.86365,
25.11181, 27.009934, 27.169749, 26.512374, 23.708805, 15.977213,
13.009108, 10.822224, 9.211607, 8.323574, 7.59577, 7.266137,
7.005706, 6.727699, 6.369471, 6.239131, 6.016894, 5.853161, 5.900408,
6.48463, 10.397005, 12.633813, 17.612896, 16.364302, 20.452238,
19.799518, 14.833054, 19.701729, 14.364708, 10.906438, 8.928268,
7.817987, 7.236737, 6.720766, 6.333781, 6.070468, 5.736166, 5.429329,
5.192251, 4.933578, 4.717896, 4.581627, 5.231772, 5.758013, 7.454312,
11.181995, 17.001151, 21.138131, 24.014042, 25.554013, 26.226573,
25.138504, 23.547719, 15.80978, 12.000338, 10.099508, 8.842024,
8.218491, 7.638029, 7.072217, 6.616829, 6.163859, 5.836507, 5.62739,
5.426227, 5.107931, 4.980874, 6.583219, 8.388053, 9.117857, 16.593475,
20.774481, 23.418055, 23.502773, 25.360302, 24.931671, 23.072692,
15.214127, 11.621692, 9.746255, 8.603993, 7.623432, 7.091371),
X90.000000 = c(10.712304, 9.923939, 9.191864, 8.509457, 8.087868,
7.737154, 7.4396, 7.522534, 7.898367, 8.555117, 10.049776,
11.859295, 12.977442, 13.162036, 13.401979, 14.199057, 14.989662,
14.706736, 13.88045, 12.924513, 12.011546, 11.195617, 10.474682,
9.839661, 9.271885, 8.770015, 8.331162, 7.938487, 7.576795,
7.254075, 6.983828, 6.792184, 7.396653, 8.656478, 10.342953,
12.243884, 14.196183, 15.98521, 17.382801, 18.344498, 18.664676,
17.755507, 16.519826, 15.264381, 14.098866, 13.104444, 12.261393,
11.579237, 11.025163, 10.55823, 10.139161, 9.784243, 9.467553,
9.18549, 8.960889, 8.862008, 9.35219, 10.111476, 11.432082,
12.323915, 13.538499, 14.426204, 14.353668, 14.903172, 14.65989,
13.88462, 12.959301, 12.089223, 11.354323, 10.732654, 10.205974,
9.763043, 9.369731, 9.012515, 8.690935, 8.393409, 8.119163,
7.874553, 7.768225, 7.764263, 8.004032, 8.745865, 10.211127,
12.016213, 13.85322, 15.493633, 16.842216, 17.711367, 18.124544,
17.301631, 16.003699, 14.720404, 13.589136, 12.666246, 11.90251,
11.246535, 10.676848, 10.167702, 9.718143, 9.330555, 8.991511,
8.670829, 8.388637, 8.391418, 8.67424, 9.013126, 10.351695,
12.103138, 13.868849, 15.234429, 16.514316, 17.450126, 17.885416,
17.047554, 15.760954, 14.490711, 13.383764, 12.42672, 11.634523
), X100.000000 = c(11.208119, 10.464276, 9.755442, 9.088719,
8.649063, 8.27841, 7.961522, 7.921398, 8.150806, 8.642336,
9.780841, 11.297569, 12.438811, 12.858763, 13.150615, 13.793257,
14.511557, 14.5081, 13.959764, 13.186099, 12.378425, 11.620135,
10.931936, 10.314882, 9.758202, 9.25974, 8.817842, 8.421102,
8.056771, 7.72758, 7.443576, 7.225312, 7.573556, 8.510587,
9.889471, 11.533048, 13.288122, 14.969329, 16.372967, 17.416581,
17.933949, 17.475201, 16.552707, 15.491744, 14.444761, 13.506899,
12.690577, 12.008692, 11.44411, 10.966387, 10.542381, 10.176092,
9.850697, 9.559918, 9.318064, 9.175695, 9.465264, 10.045213,
11.088103, 11.951898, 13.006734, 13.886568, 14.067375, 14.515449,
14.473589, 13.947295, 13.196949, 12.422684, 11.727417, 11.122533,
10.600667, 10.154182, 9.758924, 9.400655, 9.076056, 8.776485,
8.499472, 8.248842, 8.100648, 8.048147, 8.188398, 8.723638,
9.856391, 11.372675, 13.013445, 14.560278, 15.893581, 16.851597,
17.408422, 17.013723, 16.060271, 14.97122, 13.939808, 13.05371,
12.303586, 11.655306, 11.088381, 10.581541, 10.129912, 9.734408,
9.386257, 9.062775, 8.772667, 8.68843, 8.847523, 9.105772,
10.083806, 11.522212, 13.090484, 14.425589, 15.657152, 16.631722,
17.202468, 16.796552, 15.845251, 14.7633, 13.748502, 12.841227,
12.065338), X150.000000 = c(12.772535, 12.225143, 11.676934,
11.140633, 10.747878, 10.388522, 10.061439, 9.851182, 9.781987,
9.869028, 10.267483, 10.930563, 11.584466, 12.020477, 12.365721,
12.80146, 13.280824, 13.512989, 13.476304, 13.249704, 12.912089,
12.520017, 12.107123, 11.693479, 11.288709, 10.900408, 10.533873,
10.189144, 9.86352, 9.558319, 9.2781, 9.032462, 9.011353,
9.283141, 9.837304, 10.622674, 11.573735, 12.599655, 13.589469,
14.465484, 15.123994, 15.349168, 15.245356, 14.931187, 14.496242,
14.013794, 13.524237, 13.058028, 12.628162, 12.235221, 11.872275,
11.541425, 11.237903, 10.958945, 10.709243, 10.509095, 10.489117,
10.63972, 11.038721, 11.47748, 12.041772, 12.603443, 12.931364,
13.300245, 13.480579, 13.421962, 13.185496, 12.849727, 12.4772,
12.099524, 11.733605, 11.389307, 11.065818, 10.761122, 10.475045,
10.205103, 9.950192, 9.711572, 9.518042, 9.37629, 9.328081,
9.463871, 9.89286, 10.582364, 11.444694, 12.376394, 13.29402,
14.097612, 14.731634, 14.956169, 14.829092, 14.490791, 14.04734,
13.574687, 13.107913, 12.659427, 12.235273, 11.83519, 11.460843,
11.114999, 10.796672, 10.498399, 10.221858, 10.031465, 9.961257,
9.97583, 10.302642, 10.914426, 11.70651, 12.520021, 13.346788,
14.106576, 14.711006, 14.906302, 14.758757, 14.406192, 13.955831,
13.466155, 12.979275), X200.000000 = c(13.662256, 13.277453,
12.876093, 12.473001, 12.157226, 11.853491, 11.564894, 11.323543,
11.152883, 11.070238, 11.140347, 11.377243, 11.693451, 11.979273,
12.23059, 12.505799, 12.811191, 13.04626, 13.158984, 13.15099,
13.046876, 12.874723, 12.657629, 12.4129, 12.152266, 11.884579,
11.616656, 11.352509, 11.093856, 10.842697, 10.602142, 10.377485,
10.238989, 10.242604, 10.412201, 10.744122, 11.217117, 11.792032,
12.413283, 13.028276, 13.574836, 13.945636, 14.125938, 14.144688,
14.041266, 13.856299, 13.621311, 13.361719, 13.094772, 12.830041,
12.571031, 12.321547, 12.082748, 11.855127, 11.641306, 11.450219,
11.332736, 11.30866, 11.416677, 11.602095, 11.874193, 12.191859,
12.455405, 12.717466, 12.915819, 13.004091, 12.980711, 12.869339,
12.700059, 12.496301, 12.274584, 12.046527, 11.81804, 11.592109,
11.370932, 11.155352, 10.945958, 10.743928, 10.560385, 10.40294,
10.29043, 10.264056, 10.382032, 10.660754, 11.079938, 11.597014,
12.16512, 12.727789, 13.238679, 13.588971, 13.747536, 13.744299,
13.624703, 13.432885, 13.200142, 12.945579, 12.681321, 12.41426,
12.149523, 11.891614, 11.643215, 11.403754, 11.174313, 10.978815,
10.840367, 10.757738, 10.812945, 11.033663, 11.398563, 11.845283,
12.345243, 12.856565, 13.327941, 13.644071, 13.774331, 13.748016,
13.610755, 13.40057, 13.148583), X500.000000 = c(14.582667,
14.562284, 14.536874, 14.512822, 14.482134, 14.447207, 14.408029,
14.364724, 14.317598, 14.267173, 14.214283, 14.160112, 14.106025,
14.053285, 14.002921, 13.955783, 13.912587, 13.87379, 13.839459,
13.809259, 13.782526, 13.758381, 13.735847, 13.713947, 13.691774,
13.668527, 13.643544, 13.616299, 13.586404, 13.553592, 13.517707,
13.4787, 13.436726, 13.392269, 13.346201, 13.299766, 13.254493,
13.212057, 13.174108, 13.14209, 13.117071, 13.099524, 13.089255,
13.085486, 13.087025, 13.092446, 13.10026, 13.109048, 13.117549,
13.124707, 13.129678, 13.131828, 13.130711, 13.126043, 13.11768,
13.105608, 13.090013, 13.071319, 13.050253, 13.027746, 13.004883,
12.982786, 12.962397, 12.944461, 12.929458, 12.917492, 12.908293,
12.901287, 12.895714, 12.890736, 12.885534, 12.879366, 12.871603,
12.861743, 12.849404, 12.834319, 12.816321, 12.795325, 12.771338,
12.744458, 12.714903, 12.683077, 12.649673, 12.615726, 12.582559,
12.55166, 12.524517, 12.502455, 12.486485, 12.477085, 12.474099,
12.4768, 12.484057, 12.494527, 12.50682, 12.519625, 12.531775,
12.542288, 12.550375, 12.555435, 12.557042, 12.554919, 12.548919,
12.539039, 12.525451, 12.508497, 12.488802, 12.467349, 12.44543,
12.424493, 12.406, 12.391283, 12.381404, 12.37692, 12.377771,
12.383336, 12.392597, 12.404317, 12.417202), X1000.000000 = c(13.184515,
13.177372, 13.169338, 13.163191, 13.156977, 13.150688, 13.144312,
13.137837, 13.131249, 13.124533, 13.117673, 13.110656, 13.103469,
13.096102, 13.088549, 13.080805, 13.072872, 13.064752, 13.056453,
13.047984, 13.039355, 13.03058, 13.021671, 13.012638, 13.003494,
12.994245, 12.984898, 12.975459, 12.965928, 12.956306, 12.94659,
12.936775, 12.926856, 12.916826, 12.906676, 12.8964, 12.885994,
12.875454, 12.864783, 12.853986, 12.843074, 12.832061, 12.820968,
12.809816, 12.798629, 12.78743, 12.776243, 12.76509, 12.753989,
12.742956, 12.732003, 12.72114, 12.71037, 12.699697, 12.689119,
12.678632, 12.668229, 12.657902, 12.647641, 12.637438, 12.627283,
12.617169, 12.60709, 12.597042, 12.587026, 12.577042, 12.567094,
12.557186, 12.547323, 12.53751, 12.527751, 12.518048, 12.508403,
12.498815, 12.489282, 12.479799, 12.470361, 12.460958, 12.451582,
12.442222, 12.432866, 12.423504, 12.414122, 12.40471, 12.395259,
12.385761, 12.376215, 12.366621, 12.356984, 12.347315, 12.337627,
12.327937, 12.318263, 12.308623, 12.299035, 12.289516, 12.280078,
12.270734, 12.261491, 12.252353, 12.243323, 12.234399, 12.225575,
12.216846, 12.208201, 12.19963, 12.191121, 12.182661, 12.17424,
12.165848, 12.157478, 12.149128, 12.140797, 12.132491, 12.124217,
12.115986, 12.10781, 12.099702, 12.091673), X2000.000000 = c(8.632455,
8.63457, 8.63491, 8.636754, 8.638591, 8.640422, 8.642245,
8.644062, 8.645871, 8.647673, 8.649468, 8.651255, 8.653034,
8.654805, 8.656567, 8.658322, 8.660068, 8.661805, 8.663533,
8.665252, 8.666962, 8.668662, 8.670353, 8.672034, 8.673705,
8.675366, 8.677016, 8.678656, 8.680285, 8.681903, 8.683509,
8.685105, 8.686689, 8.688262, 8.689822, 8.691371, 8.692907,
8.694432, 8.695943, 8.697442, 8.698928, 8.700401, 8.701861,
8.703307, 8.70474, 8.706159, 8.707564, 8.708955, 8.710332,
8.711695, 8.713043, 8.714376, 8.715695, 8.717, 8.718289,
8.719564, 8.720823, 8.722068, 8.723297, 8.724511, 8.72571,
8.726893, 8.728061, 8.729214, 8.730351, 8.731473, 8.73258,
8.73367, 8.734746, 8.735805, 8.736849, 8.737878, 8.738891,
8.739888, 8.74087, 8.741836, 8.742786, 8.743721, 8.744641,
8.745544, 8.746433, 8.747305, 8.748163, 8.749004, 8.74983,
8.750641, 8.751437, 8.752216, 8.752981, 8.75373, 8.754463,
8.755182, 8.755884, 8.756572, 8.757244, 8.7579, 8.758542,
8.759168, 8.759779, 8.760375, 8.760955, 8.76152, 8.762071,
8.762606, 8.763127, 8.763632, 8.764123, 8.764599, 8.76506,
8.765507, 8.765939, 8.766357, 8.76676, 8.767149, 8.767524,
8.767885, 8.768231, 8.768564, 8.768883), X3000.000000 = c(5.160646,
5.163006, 5.165373, 5.167737, 5.170099, 5.172459, 5.174816,
5.177171, 5.179524, 5.181874, 5.184222, 5.186567, 5.18891,
5.191251, 5.193589, 5.195925, 5.198258, 5.200589, 5.202918,
5.205244, 5.207568, 5.209889, 5.212208, 5.214524, 5.216838,
5.219149, 5.221458, 5.223764, 5.226068, 5.228369, 5.230668,
5.232964, 5.235257, 5.237548, 5.239836, 5.242122, 5.244404,
5.246685, 5.248962, 5.251237, 5.253509, 5.255779, 5.258045,
5.260309, 5.26257, 5.264829, 5.267084, 5.269337, 5.271587,
5.273834, 5.276078, 5.27832, 5.280558, 5.282793, 5.285026,
5.287255, 5.289482, 5.291706, 5.293926, 5.296144, 5.298358,
5.300569, 5.302778, 5.304983, 5.307185, 5.309384, 5.31158,
5.313772, 5.315961, 5.318147, 5.32033, 5.32251, 5.324686,
5.326859, 5.329029, 5.331196, 5.333359, 5.335518, 5.337675,
5.339827, 5.341977, 5.344123, 5.346266, 5.348405, 5.35054,
5.352672, 5.354801, 5.356926, 5.359048, 5.361166, 5.36328,
5.365391, 5.367498, 5.369601, 5.371701, 5.373797, 5.37589,
5.377978, 5.380064, 5.382145, 5.384222, 5.386296, 5.388366,
5.390432, 5.392495, 5.394553, 5.396608, 5.398659, 5.400706,
5.402749, 5.404788, 5.406824, 5.408855, 5.410882, 5.412906,
5.414925, 5.416941, 5.418953, 5.42096), X4000.000000 = c(3.078902,
3.080237, 3.081781, 3.083323, 3.084865, 3.086406, 3.087947,
3.089486, 3.091025, 3.092563, 3.094101, 3.095637, 3.097173,
3.098708, 3.100242, 3.101775, 3.103308, 3.10484, 3.106371,
3.107901, 3.109431, 3.11096, 3.112488, 3.114015, 3.115542,
3.117067, 3.118592, 3.120117, 3.12164, 3.123163, 3.124685,
3.126206, 3.127726, 3.129246, 3.130765, 3.132283, 3.1338,
3.135316, 3.136832, 3.138347, 3.139861, 3.141375, 3.142888,
3.1444, 3.145911, 3.147421, 3.148931, 3.15044, 3.151948,
3.153455, 3.154961, 3.156467, 3.157972, 3.159476, 3.16098,
3.162483, 3.163984, 3.165486, 3.166986, 3.168486, 3.169984,
3.171482, 3.17298, 3.174476, 3.175972, 3.177467, 3.178961,
3.180454, 3.181947, 3.183438, 3.184929, 3.18642, 3.187909,
3.189398, 3.190885, 3.192373, 3.193859, 3.195344, 3.196829,
3.198313, 3.199796, 3.201278, 3.202759, 3.20424, 3.20572,
3.207199, 3.208677, 3.210155, 3.211631, 3.213107, 3.214582,
3.216056, 3.21753, 3.219002, 3.220474, 3.221945, 3.223415,
3.224884, 3.226353, 3.22782, 3.229287, 3.230753, 3.232218,
3.233682, 3.235146, 3.236608, 3.23807, 3.239531, 3.240991,
3.24245, 3.243909, 3.245366, 3.246823, 3.248279, 3.249734,
3.251188, 3.252641, 3.254093, 3.255545), X5000.000000 = c(2.025982,
2.025779, 2.025689, 2.0256, 2.025512, 2.025427, 2.025343,
2.025262, 2.025182, 2.025103, 2.025027, 2.024952, 2.024879,
2.024808, 2.024739, 2.024671, 2.024605, 2.024541, 2.024479,
2.024418, 2.024359, 2.024302, 2.024247, 2.024193, 2.024141,
2.024091, 2.024043, 2.023996, 2.023951, 2.023907, 2.023866,
2.023826, 2.023788, 2.023751, 2.023716, 2.023683, 2.023651,
2.023622, 2.023593, 2.023567, 2.023542, 2.023519, 2.023498,
2.023478, 2.02346, 2.023443, 2.023428, 2.023415, 2.023403,
2.023393, 2.023385, 2.023378, 2.023373, 2.02337, 2.023368,
2.023368, 2.023369, 2.023372, 2.023377, 2.023383, 2.023391,
2.0234, 2.023411, 2.023424, 2.023438, 2.023454, 2.023471,
2.02349, 2.02351, 2.023533, 2.023556, 2.023581, 2.023608,
2.023636, 2.023666, 2.023697, 2.02373, 2.023765, 2.023801,
2.023838, 2.023877, 2.023918, 2.02396, 2.024003, 2.024048,
2.024095, 2.024143, 2.024193, 2.024244, 2.024296, 2.02435,
2.024406, 2.024463, 2.024522, 2.024582, 2.024643, 2.024706,
2.02477, 2.024836, 2.024904, 2.024973, 2.025043, 2.025115,
2.025188, 2.025262, 2.025338, 2.025416, 2.025495, 2.025575,
2.025657, 2.02574, 2.025825, 2.025911, 2.025999, 2.026088,
2.026178, 2.02627, 2.026363, 2.026457), X6000.000000 = c(0.874807,
0.874713, 0.874667, 0.874622, 0.874578, 0.874534, 0.874491,
0.87445, 0.874408, 0.874368, 0.874329, 0.87429, 0.874252,
0.874215, 0.874178, 0.874142, 0.874108, 0.874073, 0.87404,
0.874008, 0.873976, 0.873945, 0.873914, 0.873885, 0.873856,
0.873828, 0.873801, 0.873774, 0.873749, 0.873724, 0.8737,
0.873676, 0.873653, 0.873631, 0.87361, 0.87359, 0.87357,
0.873551, 0.873533, 0.873515, 0.873498, 0.873482, 0.873467,
0.873452, 0.873439, 0.873425, 0.873413, 0.873401, 0.87339,
0.87338, 0.873371, 0.873362, 0.873354, 0.873346, 0.87334,
0.873334, 0.873328, 0.873324, 0.87332, 0.873317, 0.873315,
0.873313, 0.873312, 0.873312, 0.873312, 0.873313, 0.873315,
0.873317, 0.87332, 0.873324, 0.873329, 0.873334, 0.87334,
0.873347, 0.873354, 0.873362, 0.87337, 0.87338, 0.87339,
0.8734, 0.873412, 0.873424, 0.873437, 0.87345, 0.873464,
0.873479, 0.873494, 0.87351, 0.873527, 0.873544, 0.873562,
0.873581, 0.8736, 0.87362, 0.873641, 0.873662, 0.873684,
0.873706, 0.87373, 0.873753, 0.873778, 0.873803, 0.873829,
0.873855, 0.873882, 0.87391, 0.873938, 0.873967, 0.873997,
0.874027, 0.874058, 0.87409, 0.874122, 0.874154, 0.874188,
0.874222, 0.874256, 0.874292, 0.874327), X7000.000000 = c(-0.00084,
-0.000839, -0.000838, -0.000837, -0.000836, -0.000835, -0.000834,
-0.000833, -0.000832, -0.000831, -0.00083, -0.000829, -0.000828,
-0.000827, -0.000826, -0.000825, -0.000824, -0.000823, -0.000822,
-0.000821, -0.000819, -0.000818, -0.000817, -0.000816, -0.000815,
-0.000814, -0.000813, -0.000812, -0.000811, -0.00081, -0.000809,
-0.000808, -0.000807, -0.000806, -0.000805, -0.000804, -0.000803,
-0.000802, -8e-04, -0.000799, -0.000798, -0.000797, -0.000796,
-0.000795, -0.000794, -0.000793, -0.000792, -0.000791, -0.00079,
-0.000789, -0.000788, -0.000787, -0.000786, -0.000784, -0.000783,
-0.000782, -0.000781, -0.00078, -0.000779, -0.000778, -0.000777,
-0.000776, -0.000775, -0.000774, -0.000773, -0.000772, -0.000771,
-0.000769, -0.000768, -0.000767, -0.000766, -0.000765, -0.000764,
-0.000763, -0.000762, -0.000761, -0.00076, -0.000759, -0.000758,
-0.000757, -0.000755, -0.000754, -0.000753, -0.000752, -0.000751,
-0.00075, -0.000749, -0.000748, -0.000747, -0.000746, -0.000745,
-0.000743, -0.000742, -0.000741, -0.00074, -0.000739, -0.000738,
-0.000737, -0.000736, -0.000735, -0.000734, -0.000733, -0.000731,
-0.00073, -0.000729, -0.000728, -0.000727, -0.000726, -0.000725,
-0.000724, -0.000723, -0.000722, -0.00072, -0.000719, -0.000718,
-0.000717, -0.000716, -0.000715, -0.000714), X8000.000000 = c(-0.000841,
-0.00084, -0.00084, -0.000839, -0.000839, -0.000838, -0.000837,
-0.000837, -0.000836, -0.000836, -0.000835, -0.000834, -0.000834,
-0.000833, -0.000833, -0.000832, -0.000831, -0.000831, -0.00083,
-0.00083, -0.000829, -0.000829, -0.000828, -0.000827, -0.000827,
-0.000826, -0.000826, -0.000825, -0.000824, -0.000824, -0.000823,
-0.000823, -0.000822, -0.000821, -0.000821, -0.00082, -0.00082,
-0.000819, -0.000819, -0.000818, -0.000817, -0.000817, -0.000816,
-0.000816, -0.000815, -0.000814, -0.000814, -0.000813, -0.000813,
-0.000812, -0.000811, -0.000811, -0.00081, -0.00081, -0.000809,
-0.000808, -0.000808, -0.000807, -0.000807, -0.000806, -0.000805,
-0.000805, -0.000804, -0.000804, -0.000803, -0.000802, -0.000802,
-0.000801, -0.000801, -8e-04, -0.000799, -0.000799, -0.000798,
-0.000798, -0.000797, -0.000796, -0.000796, -0.000795, -0.000795,
-0.000794, -0.000793, -0.000793, -0.000792, -0.000792, -0.000791,
-0.00079, -0.00079, -0.000789, -0.000789, -0.000788, -0.000787,
-0.000787, -0.000786, -0.000786, -0.000785, -0.000784, -0.000784,
-0.000783, -0.000783, -0.000782, -0.000781, -0.000781, -0.00078,
-0.000779, -0.000779, -0.000778, -0.000778, -0.000777, -0.000776,
-0.000776, -0.000775, -0.000775, -0.000774, -0.000773, -0.000773,
-0.000772, -0.000771, -0.000771, -0.00077), X9000.000000 = c(-0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.00084,
-0.00084, -0.00084, -0.00084, -0.00084, -0.00084, -0.00084,
-0.00084, -0.00084, -0.000839, -0.000839, -0.000839, -0.000839,
-0.000839, -0.000839, -0.000839, -0.000839, -0.000838, -0.000838,
-0.000838, -0.000838, -0.000838, -0.000838, -0.000838, -0.000838,
-0.000837, -0.000837, -0.000837, -0.000837, -0.000837, -0.000837,
-0.000837, -0.000837, -0.000836, -0.000836, -0.000836, -0.000836,
-0.000836, -0.000836, -0.000836, -0.000836, -0.000836, -0.000835,
-0.000835, -0.000835, -0.000835, -0.000835, -0.000835, -0.000835,
-0.000835, -0.000834, -0.000834, -0.000834, -0.000834, -0.000834,
-0.000834, -0.000834, -0.000834, -0.000833, -0.000833, -0.000833,
-0.000833, -0.000833, -0.000833, -0.000833, -0.000833, -0.000832,
-0.000832, -0.000832, -0.000832, -0.000832, -0.000832, -0.000832,
-0.000832, -0.000831, -0.000831, -0.000831, -0.000831, -0.000831,
-0.000831, -0.000831, -0.000831, -0.00083, -0.00083, -0.00083,
-0.00083, -0.00083, -0.00083, -0.00083, -0.00083, -0.000829,
-0.000829, -0.000829, -0.000829, -0.000829, -0.000829, -0.000829,
-0.000829, -0.000828, -0.000828, -0.000828, -0.000828, -0.000828,
-0.000828, -0.000828, -0.000828, -0.000827, -0.000827, -0.000827,
-0.000827, -0.000827, -0.000827, -0.000827), X10000.000000 = c(-0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841, -0.000841, -0.000841,
-0.000841, -0.000841, -0.000841, -0.000841), Date = structure(c(1441049400,
1441053000, 1441056600, 1441060200, 1441063800, 1441067400,
1441071000, 1441074600, 1441078200, 1441081800, 1441085400,
1441089000, 1441092600, 1441096200, 1441099800, 1441103400,
1441107000, 1441110600, 1441114200, 1441117800, 1441121400,
1441125000, 1441128600, 1441132200, 1441135800, 1441139400,
1441143000, 1441146600, 1441150200, 1441153800, 1441157400,
1441161000, 1441164600, 1441168200, 1441171800, 1441175400,
1441179000, 1441182600, 1441186200, 1441189800, 1441193400,
1441197000, 1441200600, 1441204200, 1441207800, 1441211400,
1441215000, 1441218600, 1441222200, 1441225800, 1441229400,
1441233000, 1441236600, 1441240200, 1441243800, 1441247400,
1441251000, 1441254600, 1441258200, 1441261800, 1441265400,
1441269000, 1441272600, 1441276200, 1441279800, 1441283400,
1441287000, 1441290600, 1441294200, 1441297800, 1441301400,
1441305000, 1441308600, 1441312200, 1441315800, 1441319400,
1441323000, 1441326600, 1441330200, 1441333800, 1441337400,
1441341000, 1441344600, 1441348200, 1441351800, 1441355400,
1441359000, 1441362600, 1441366200, 1441369800, 1441373400,
1441377000, 1441380600, 1441384200, 1441387800, 1441391400,
1441395000, 1441398600, 1441402200, 1441405800, 1441409400,
1441413000, 1441416600, 1441420200, 1441423800, 1441427400,
1441431000, 1441434600, 1441438200, 1441441800, 1441445400,
1441449000, 1441452600, 1441456200, 1441459800, 1441463400,
1441467000, 1441470600, 1441474200), class = c("POSIXct",
"POSIXt"), tzone = "Asia/Kolkata")), row.names = 2:120, class = "data.frame")
After that I tried to make a tidy dataset using the following code:
# Tidy soil temperature data
library(tidyverse)
library(viridis)
tidy_tbl <- as_tibble(indata) %>%
gather(key = "depth", value = "temp", starts_with("X")) %>%
separate(depth, c("X", "depth"), sep = 1) %>%
mutate_at(vars(depth), as.numeric) %>%
select(-X) %>%
arrange(Date, depth) %>%
mutate(depth = -depth / 1000) %>%
select(2,1,3)
And Finally plotted as :
# Ploting the tidy data
ggplot(data = tidy_tbl, aes(x = Date, y = depth, fill = temp)) +
theme_bw() +
geom_tile() +
scale_fill_viridis(name = "Temp") +
labs(x = "Date", y = "Depth")
I got the following figure
But I need something like below
I hope I explained my problem very well!
Thanks with regards,
John